Forum Discussion
Solved
Treating if(isblank) as a series
Hello, I have a spreadsheet to track my bills. When I pay a bill, I enter the date paid in the F column and the amount I owe is represented in the G column. When I enter any value into an F cell, the...
=SUM($G$3:$G$10)+SUMPRODUCT(N(IF(ISBLANK($F$3:$F$10),0,-$G$3:$G$10)))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
I can't but help thinking you are over-complicating the problem. An simpler alternative to subtracting the amounts from the overall total when dates are inserted, would be not to add them in the first place.
= SUMIFS(amount, date, "")
That is certainly the streamlined approach for my problem!
Both great responses, always good to know different approaches.
Both great responses, always good to know different approaches.