YTD totals

[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

 

[Max]

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

is equivalent to B6: =SUM(B55)
[ 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

 

[Max]

A little clarification ..

so the answer lies in the contents in C5 and D5

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