YTD total but really showing the Current Month data

In the YTD total it's really displaying the Current month data such as if the last month entered was Mar 2008, then it would show only March 2008 data, not the summary of Jan - Mar 2008.

I tried inputing a Nested If statement for YTD but it errors on row 6. Could you take a look and let me know of a way to accomplish this from Dec 2008 backwards to Jan 2008 for all months?

Thank you,

CC

rather than nested IFs, why are you not using SUM or SUBTOTAL?

Because the requirement is to display the Current Month's data, not the summary or subtotal.

That isn't what they want. The YTD total is not YTD really, it's Current Month. So in your example the YTD would have been 5 for April because that is the last month with data. They don't want any summaries, ONLY the current month's data. In my case it would show $0 for the unfilled months.

I didn't mean to be rude, I was just trying to explain so you would understand. Sorry!

CC

well if you enter the following as an array ( instead of pressing enter, hold down ctrl and shift together and with them still held down press enter)

=INDEX(B3:B14,MAX(IF(B3:B14>0,ROW(A1:A12),0)))

That should work

Let me know

Regards

Dav