Forum Discussion
Solved
sumif simple budget sheet
I have a sheet that has column C as last months expenditure and column D as this months expenditure. As I progress through the month I want an idea of how much I need to get to the end of the month....
- There must be a difference between your Excel release and my 365 release.
=SUM(D3:D12)+SUMIF(D3:D12,"",C3:C12) does not work
but;
=SUM(D3:D12)+SUMIF(D3:D12,0,C3:C12) works if I enter a zero in those blank cells. That's not quite good enough just for data entry sake. I formatted that column as numeric with 2 decimal places but that didn't do anything. Anyway, you did a good job of trouble shooting the formula.
Almost the same what I had earlier. Replace the 0 with "". Just make sure the empty cells in D are really empty.
There must be a difference between your Excel release and my 365 release.
=SUM(D3:D12)+SUMIF(D3:D12,"",C3:C12) does not work
but;
=SUM(D3:D12)+SUMIF(D3:D12,0,C3:C12) works if I enter a zero in those blank cells. That's not quite good enough just for data entry sake. I formatted that column as numeric with 2 decimal places but that didn't do anything. Anyway, you did a good job of trouble shooting the formula.
=SUM(D3:D12)+SUMIF(D3:D12,"",C3:C12) does not work
but;
=SUM(D3:D12)+SUMIF(D3:D12,0,C3:C12) works if I enter a zero in those blank cells. That's not quite good enough just for data entry sake. I formatted that column as numeric with 2 decimal places but that didn't do anything. Anyway, you did a good job of trouble shooting the formula.