Sep 10 2022 10:38 PM
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. If column D is zero I want to assume the value in column C.
=SUMIF( D15:D44,"=0",C15:C44 )
The result is 0.00.
Day | Description | Last Month Amt | This Month Amt |
2nd | Boost | 59.00 | 59.00 |
2nd | Boost | 35.00 | 35.00 |
3rd | Signature | 200.00 | 200.00 |
Microsoft | 1.99 | ||
3rd | Amazon Music | 7.99 | |
13th | Mercury CC | 901.24 | |
13th | Merrick CC | 1116.13 | |
9th | Balance of Nature | 69.95 | |
9th | Foremost Insurance | 162.57 |
I thought this was going to be really simple.
Sep 10 2022 10:47 PM
@larksys That could be something like this:
=SUM(D15:D44)+SUMIF(D15:D44,0,C15:C44)
Unless I misinterpreted your intentions.
Sep 11 2022 05:04 PM
Sep 11 2022 10:14 PM
@larksys Please clarify/show how the end result should be.
Sep 12 2022 07:45 AM
A B C D
Day | Description | Last Month Amt | This Month Amt |
2nd | Boost | 59.00 | 59.00 |
2nd | Boost | 35.00 | 35.00 |
3rd | Signature | 200.00 | 200.00 |
Microsoft | 1.99 | ||
3rd | Amazon Music | 7.99 | |
13th | Mercury CC | 901.24 | |
13th | Merrick CC | 1116.13 | |
9th | Balance of Nature | 69.95 | |
9th | Foremost Insurance | 162.57 |
should get 2553.87
corrected formula for this example;
=SUM(D3:D12)+SUMIF(D3:D12,"=0",C3:C12)
Sep 12 2022 08:09 AM
Almost the same what I had earlier. Replace the 0 with "". Just make sure the empty cells in D are really empty.
Sep 12 2022 09:50 AM
SolutionSep 12 2022 09:50 AM
Solution