SUMIF multiple criteria
Hi
Try something like this:
=SUMPRODUCT(--(A2:A100="Activity 120"),--(A2:A100<="Activity
129"),--(B2:B100))
Hope this helps.
Andy.
"HLS" wrote in message
...
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?
|