How to use SUMIF and the criteria is a range of values

Taima El Frieh

Hi Everyone!

Can anyone help me with that. I'm trying to use sumif function for a range of values. for example: I want to sum a values in a column if they range between 50 and 60. How can I do that?

I used: = SUMIF( mycolumn, AND(mycolumn >50 , mycolumn <=60)) but its not working. Thank you

Mark Cronk

Hi @Taima El Frieh ,

Try:

= SUMIF(mycolumn:mycolumn, AND(@cell >50, @cell<=60))

Mark

Taima El Frieh

Thank you! it did work.

If I want to add another criteria, I want the formula to check if a specific column has a row that is not blank, then it will add values in another column

I tried:

=SUMIFS({referenced column from another sheet}, {another referenced column from another sheet}, NOT(ISBLANK(@row))

Do you have any thoughts about this? Thank you.

Mark Cronk

Hi @Taima El Frieh ,

For your formula to work the range {referenced column from another sheet} column needs to be numbers and can't contain any errors. The range {another referenced column from another sheet} column can be text, date, contact, or symbol but not a check box.

=SUMIFS({referenced column from another sheet}, {another referenced column from another sheet}, NOT(ISBLANK(@row))

Work for you?

Mark

Mark Cronk

Hi @Taima El Frieh ,

Try:

= SUMIF(mycolumn:mycolumn, AND(@cell >50, @cell<=60))

Mark

Taima El Frieh

Thank you! it did work.

If I want to add another criteria, I want the formula to check if a specific column has a row that is not blank, then it will add values in another column

I tried:

=SUMIFS({referenced column from another sheet}, {another referenced column from another sheet}, NOT(ISBLANK(@row))

Do you have any thoughts about this? Thank you.

Mark Cronk

Hi @Taima El Frieh ,

For your formula to work the range {referenced column from another sheet} column needs to be numbers and can't contain any errors. The range {another referenced column from another sheet} column can be text, date, contact, or symbol but not a check box.

=SUMIFS({referenced column from another sheet}, {another referenced column from another sheet}, NOT(ISBLANK(@row))

Work for you?

Mark

Taima El Frieh

That worked for me! Thanks.

Mark Cronk

Glad to help. Thank you for using the Community.

Be Well,

Mark