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

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

Steve wrote:
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!!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html