YTD totals

  • Thread starter Thread starter GerryK
  • Start date Start date
G

GerryK

Hi,
I'm trying to get YTD's along Row 6.
In B4 I have $1000.00 (January)
In B5 I add in O/H of 19% (B4*1.19)
In B6 I have:
=SUM(INDIRECT("B5:"&CHAR(MONTH(TODAY())+64)&"5"))

My problem is B6 shows $3712.80 not $2190.00 as I expect.

This senario repeats to Column M for December.

Could someone tell me if the formula is wrong!

Thanks
 
B6: =SUM(INDIRECT("B5:"&CHAR(MONTH(TODAY())+64)&"5"))

is equivalent to B6: =SUM(B5:D5)
[ in the month of April ]

as CHAR(MONTH(TODAY())+64) evaluates to "D" [ in April ]

So B6 will return the sum of cells B5 to D5 [ in April ]

B5 will evaluate to $1190 as mentioned in your post,
so the answer lies in the contents in C5 and D5
 
A little clarification ..
so the answer lies in the contents in C5 and D5
Click to expand...

The "answer" in the line above should read as
"answer to the discrepancy returned by the formula"
 
Back
Top