sum year to date totals for particular month

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?
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

YEAR TO DATE SUM 3
annualize sales for remainder of year 3
DGET lookup failing 6
Conditional SUM for Budget, Actuals, & Variance YTD columns 0
Help with year to date comparison 4
Projections Formula 1
YTD Budget Sum if Actual Month has activities 1
what function or formula can I use 6

Top