Sum If Column is not blank


Hello everybody,

Hope you are well!

I was wondering, is there a way to SUMIF when a column at a row isn't blank? For some reason, I can't come up with a formula that will sum up the volume if the countries column below is not blank.

I was able to parent them and then use the below formula, which works

=SUMIF([Column5]:[Column5], "June 26th Week", Volume:Volume)

I am just trying to see if I could use something like the below:

=SUMIF(Volume:Volume, NOT(ISBLANK([Countries - Completed Moves]:[Countries - Completed Moves])))

If it's not possible that's ok, I thought I'd ask :)

Thanks for your help!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!