sum year to date totals for particular month
If the budget is in say B2:B13, use
=SUM(B2:INDEX(B2:B13,MONTH(TODAY())))
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"irishrover" wrote in message
...
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?
|