C
Carmen Gauvin-O'Donnell
Hi there! Let's say I need to add two cells:
- Cell A1 on the current sheet, called Jun 06
- Cell K13 on the previous sheet, called May 06
The result should be a dollar amount (of last month's totals plus this
month's totals for a total-to-date amount)
If I've understood correctly, the formular is =SUM(A1+'May 06'!K13)
HOWEVER, the May 06 cell is *itself the sum of two other numbers*. This has
the result that my new formula simply won't give me the dollar amount I'm
looking for.
What am I doing wrong? Surely, there's some stupid simple mistake I'm making
here, right? It seems to me I'm just telling Excel " take the two dollar
amounts you see and add them up". Is the fact that one cell is a composite
of other cells the problem? If so, what's the fix?
Thanks a heap in advance!
Carmen
- Cell A1 on the current sheet, called Jun 06
- Cell K13 on the previous sheet, called May 06
The result should be a dollar amount (of last month's totals plus this
month's totals for a total-to-date amount)
If I've understood correctly, the formular is =SUM(A1+'May 06'!K13)
HOWEVER, the May 06 cell is *itself the sum of two other numbers*. This has
the result that my new formula simply won't give me the dollar amount I'm
looking for.
What am I doing wrong? Surely, there's some stupid simple mistake I'm making
here, right? It seems to me I'm just telling Excel " take the two dollar
amounts you see and add them up". Is the fact that one cell is a composite
of other cells the problem? If so, what's the fix?
Thanks a heap in advance!
Carmen