LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default Sum only if corresponding field is not empty

I have a table which includes the date, Expected expenditures and
actual expenditured:
Date Expected Actual
1 10 10
2 10 11
3 10 9
4 10 8
5 10 12
6 10
7 10
8 10
9 10
etc.

At the end of the date, I enter the actual expenditures for that day.
Now, for example, say it is the end of the 5th day of the month. I have
a sum function at the bottom of actual which is sum(above). How can I
get a sum of the expected only up to that current date for which i have
entered data into the actual column, so as to compare total
expenditures so far with expected expenditures up to this date? TIA

 
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
Go to Next Empty Field cassy01 Excel Discussion (Misc queries) 1 February 20th 06 10:18 AM
Stop text from stringing into next field when empty NothingButRomance Excel Worksheet Functions 7 May 17th 05 02:22 AM
Stop text from stringing into next field when empty NothingButRomance Excel Worksheet Functions 1 May 16th 05 11:09 AM
Stop text from stringing into next field when empty NothingButRomance Excel Worksheet Functions 2 May 15th 05 05:32 PM
In Bar Chart, can we display both figures and their respective %a. Airtel Excel Discussion (Misc queries) 3 March 9th 05 02:35 PM


All times are GMT +1. The time now is 07:06 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"