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

Hi @Josue RQ
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

Hi @Josue RQ
Something like this perhaps?
=IF(ISBLANK(Countries@row), "", SUMIF($Countries$1:$Countries$6, $Countries@row, $Volume$1:Volume$6))
Answers

Hi @Josue RQ
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

Hi @Josue RQ
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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 429 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!