Forum Discussion
Solved
Calculate outstanding balance
Hello!, I wonder if anyone could help please. Imagine a regular Budget type of spreadsheet Column A we have titles Column B we have figures, B32 is the Sum of the figures e.g. =Sum(B2:b30) Column...
In C32:
=SUMIF(C2:C30, "<>Y", B2:B30)
or if all cells in C2:C30 are filled with either Y or N (no blanks):
=SUMIF(C2:C30, "N", B2:B30)