Sum only if corresponding field is not empty

  • Thread starter Thread starter ShivamPoddar
  • Start date Start date
S

ShivamPoddar

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 ar
assuming that your data above starts in cell A1

=-SUMIF(C1:C9,"",B1:B9)+SUM(B1:B9
 
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.
 
Back
Top