sum year to date totals for particular month

  • Thread starter Thread starter irishrover
  • Start date Start date
I

irishrover

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?
 
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)
 
Back
Top