Thread
:
SUMIF multiple criteria in 1 range
View Single Post
#
2
Don Guillett
Posts: n/a
try this idea
=sumproduct((k2:k200={"a","b","c"})*al2:al200)
--
Don Guillett
SalesAid Software
"Mike@Q" wrote in message
...
Hi
I am having trouble summing a range of cells that meet multiple criteria.
I have 3 resources clin040, clin060 and clinmix. These resource codes
appear
in column K. Column K also contains many other resource codes. I need to
sum
all the cells in column AL that have either clin040, clin60 or clinmix in
column K.
I also need to do this over a number of sheets - clin1, clin2 clin3 etc to
clinEND, and have a total of all cells with those resources across all the
sheets.
Please help!
Reply With Quote