Forum Discussion
What is the best way to find the sum of cells that meet a specific criteria?
I am working on a log that adds up delays for each specific crane. In the range of cranes, some of the numbers overlap, like, 204, 205, 4, and 5. Previously, I though I would be able to add the range...
You may try something like this...
Sum for crane 4:
=SUMPRODUCT(--ISNUMBER(SEARCH(" 4 "," "&E8:E19&" ")),C8:C19)
Sum for crane 204:
=SUMPRODUCT(--ISNUMBER(SEARCH(" 204 "," "&E8:E19&" ")),C8:C19)
It's better to use a cell reference instead of using the hard coded values like 4 and 204 in the formula.