samedi 6 mai 2017

How to add an IF statement to a SUMPRODUCT formula in Excel

I have been trying to figure out how to add an IF statement to a SUMPRODUCT formula that I'm using, to round values to 2dp and then sum them if they are >=0.08. Here's the formula:

=SUMPRODUCT((ROUND(A1:A20,2)>=0.08)*ROUND(A1:A20,2))

This formula works perfectly if all cells have values, however, I have some cells that have formulas in them that sometimes leave them blank. So when I use the above formula, I get the #VALUE! error. I can't seem to figure out how to add an IF statement in to the above formula, which states that if a cell is blank, then make it equal to 0. Not sure if this is possible but any help would be appreciated!

Aucun commentaire:

Enregistrer un commentaire