How to put ranges in Criteria..

S

Steve

For a SUMIF formula I need to have a numerical range for the criteria. Is
this possible? It has to be a solution that lets me add up the numbers in
one column IF the criteria is met.....

Thanks for all input!!
 
D

Debra Dalgleish

You can use two SUMIFs in a formula, e.g.:

=SUMIF(B2:B28,">40")-SUMIF(B2:B28,">80")
 
Top