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

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

• ✭✭✭✭✭✭

Try:

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

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

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

• ✭✭✭✭✭✭

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

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭

Try:

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

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

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

• ✭✭✭✭✭✭

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

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• That worked for me! Thanks.

• ✭✭✭✭✭✭

Glad to help. Thank you for using the Community.

Be Well,

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!