LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
AGnes
 
Posts: n/a
Default YTD Budget Sum if Actual Month has activities

My worksheet has 50 rows showing sales for each book. It has 39 columns - 3
for each month - budget, actual and diff - and 3 more columns for YTD. They
are like this:
Jan-Budget Jan-Actual Jan-Diff Feb-Budget Feb-Actual Feb-Diff
etc.

I have budgets for each month for each book on the worksheet already. I
update it monthly to enter actual sales for the month. I want the YTD-Budget
column to only sum up months that have actual activities so I can do a fair
comparison with YTD-Actual.

I tried to create a formula that sums up the budget columns for months where
Total Actual for the month is < 0. But I didnt' get it right.

I'd appreciate if you can help me with that. Thanks in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up a Yearly, by month, budget in Excel? napaman Excel Discussion (Misc queries) 1 February 20th 05 11:31 PM
Month Year Date Format Jamie Excel Worksheet Functions 2 February 7th 05 06:43 PM
Automatically change tab reference TWC Excel Discussion (Misc queries) 2 February 2nd 05 10:17 PM
Find and Replace miket_jam Excel Discussion (Misc queries) 3 January 27th 05 02:15 AM
How to extract month number from month name PM Excel Discussion (Misc queries) 2 January 19th 05 03:07 PM


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"