No.
You will have to use a SUMPRODUCT formula instead

BTW, what do you do with activities 120, 130, 140, ... ?

HTH
--
AP

"HLS" a écrit dans le message de
...
I would like to be able to use SUMIF to return the total spent on various
activities within a dept (without having to have a separate column stating
the dept number).

Activity 121 $400
Activity 144 $700
Activity 126 $45
Activity 141 $1457

I want to SUM activities 121 - 129 and 131 - 139 and so on.

Is it possible to insert a range of criteria within the SUMIF function?