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.
=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.
That seems to work but I think I need to spend some time understanding why haha. I am going to read up on the "sumproduct(n" part of that function because it is a bit foreign to me.
Thank you for the quick response!
Thank you for the quick response!
=SUM($G$3:$G$10)+SUMPRODUCT(IF(ISBLANK($F$3:$F$10),0,-$G$3:$G$10))
You are welcome.
Actually SUMPRODUCT(IF(ISBLANK works and "N(" within SUMPRODUCT(N(IF(ISBLANK isn't required. Therefore you don't have to spend time on the "N(" part.