Sum If Column is not blank

Josue RQ

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!

Matt Johnson

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

=Chris Palmer

Hi @Josue RQ

Something like this perhaps?

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

Matt Johnson

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

=Chris Palmer

Hi @Josue RQ

Something like this perhaps?

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

Josue RQ

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