sum year to date totals for particular month



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?

Bob Phillips

If the budget is in say B2:B13, use




(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