G
Guest
Here is an example of my data:
Org criticality
score
Corporate Marketing critical 100
Human Resources critical 100
Corporate Security non-critical 75
Finance non-critical 100
Corporate Marketing critical 50
I need to search column A for a specific org & B for "critical" and sum
their values column C.
Example lookup corporate marketing & critical would add 100+50 = 150
here is the formula I'm using that
is close:
=SUMPRODUCT(SUMIF('Score Calc'!D410,{"Corporate Marketing"},'Score
Calc'!CJ4:CJ10))
I just need to know how to add another part to the array to also look up
"Critical"
Org criticality
score
Corporate Marketing critical 100
Human Resources critical 100
Corporate Security non-critical 75
Finance non-critical 100
Corporate Marketing critical 50
I need to search column A for a specific org & B for "critical" and sum
their values column C.
Example lookup corporate marketing & critical would add 100+50 = 150
here is the formula I'm using that
is close:
=SUMPRODUCT(SUMIF('Score Calc'!D410,{"Corporate Marketing"},'Score
Calc'!CJ4:CJ10))
I just need to know how to add another part to the array to also look up
"Critical"