YTD Budget Totals

G

Guest

Hi -
I need to get budgeted year-to-date totals for a budget worksheet. Range
E7:p7 has actuals for the months (Jan-Mar) YTD. Range E8:p8 has the budgeted
amounts by the months (Jan-Dec) for 2005. I need to show budgeted amounts in
Q8 only for the months in which there are acutual numbers which will give me
an actual vs. budget ytd. I would like to implement a formula so I do not
have to expand the column range 1 month manually each month.
Any help is appreciated.
Thank you
 

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

Conditional SUM for Budget, Actuals, & Variance YTD columns 0
determine a range using a formula 2
YTD budget formula based on current actual input 3
YTD Budget Totals 3
Select a range of cells 2
what function or formula can I use 6
YTD Budget Sum if Actual Month has activities 1
sum year to date totals for particular month 1

Top