Sum a range greater than >25000 based on the status of a check box


Help! I cannot figure out a formula for SUMIF or SUMIFS to add a range of numbers in a column that are greater than 25,000 based on a checkbox.

=SUMIFS({Content Limit - NB}, >25000, {Reporting - NB}, 1) <-- why doesn't this work. hehe

I keep getting #invalid operation. This formula works =SUMIF({Content Limit - NB}, >25000), but totals all the values. I need to narrow it down to the check box.

Please help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!