sum year to date totals for particular month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

irishrover - 04 Feb 2008 05:43 GMT

I have an actual sales report by month and a separate line for budget with
all 12 months. I want to generate a report monthly which will give year to
date actul and YTD budget. Actual is easy as forward months will be zero. How
do I total the proper number of months from the budget date to compare actual
versus budget?

Reply to this Message

Bob Phillips - 04 Feb 2008 08:42 GMT

If the budget is in say B2:B13, use

=SUM(B2:INDEX(B2:B13,MONTH(TODAY())))

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have an actual sales report by month and a separate line for budget with
> all 12 months. I want to generate a report monthly which will give year to
[quoted text clipped - 3 lines]
> actual
> versus budget?

Reply to this Message