Forum Discussion
Sum formula based on blank cells
I am trying to aggregate monthly percentages from different worksheets. If a numerator is 0, but there is still a denominator listed, I do not want to include the denominator in my calculation. (i.e....
Hello,
could you provide a data sample? Even a screenshot would help. It is not clear how your data is organised. If numerator and denominator are in separate cells, you can use Sumif. In the screenshot below, the formula in cell A7 is
=SUMIF(A2:A5,"<>0")
although, since you want to ignore Zero, you might as well do a simple sum.
The formula in B7 sums only the values in B2:B5 where the respective cell in A2:A5 is not zero:
=SUMIF(A2:A5,"<>0",B2:B5)
Does that get you any further?