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

Sum only if corresponding field is not empty
 

This isn't very pretty but I think it works. Cell references are
assuming that your data above starts in cell A1

=-SUMIF(C1:C9,"",B1:B9)+SUM(B1:B9)


--
germullen
------------------------------------------------------------------------
germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
View this thread: http://www.excelforum.com/showthread...hreadid=531861

Sum only if corresponding field is not empty
 

Thanks for the quick reply, worked perfectly. As you can probably tell,
i'm new to excel and am just creating a ton of sheets for everyday
applications, so I can learn how to use it.