Sum if not blank

Cheryl Collins
Cheryl Collins ✭✭✭✭✭✭
edited 02/10/21 in Formulas and Functions


I'm trying to sum 3 columns, if they are not blank (I am currently using the following formula:

=ISBLANK(SUMIF(Likelihood@row:Proximity@row, >0, Likelihood@row:Proximity@row), " ")

However, I'm getting a #incorrectargumentset error. I think it's something to do with my brackets, but what am I doing wrong?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!