# 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 :)

Tags:

• ✭✭✭✭✭✭

If I follow right, I think the formula below is what you are looking for. It sums the Volume column for only rows where the Countries column is not blank.

=SUMIF([Countries - Completed Moves]:[Countries - Completed Moves], <>"", Volume:Volume)

I hope that helps.

Matt

Matt Johnson

Sevan Technology

Smartsheet Aligned Partner

• ✭✭✭✭✭

Something like this perhaps?

=IF(ISBLANK(Countries@row), "", SUMIF(\$Countries\$1:\$Countries\$6, \$Countries@row, \$Volume\$1:Volume\$6))

• ✭✭✭✭✭✭

If I follow right, I think the formula below is what you are looking for. It sums the Volume column for only rows where the Countries column is not blank.

=SUMIF([Countries - Completed Moves]:[Countries - Completed Moves], <>"", Volume:Volume)

I hope that helps.

Matt

Matt Johnson

Sevan Technology

Smartsheet Aligned Partner

• ✭✭✭✭✭

Something like this perhaps?

=IF(ISBLANK(Countries@row), "", SUMIF(\$Countries\$1:\$Countries\$6, \$Countries@row, \$Volume\$1:Volume\$6))

• ✭✭

Thank you, Matt and Chris! Both of your solutions work :)

I thought that the NOT(BLANK was an option, so glad to see I wasn't missing something

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!