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

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

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.