sum multiple lookups?
I'm still having a hard time with that....here is the formula I'm using that
is close:
=SUMPRODUCT(SUMIF('Score Calc'!D4:D10,{"Corporate Marketing"},'Score
Calc'!CJ4:CJ10))
I just need to know how to add another part to the array to also look up
"Critical"
Can you help?? Thanks! :)
"Toppers" wrote:
=SUMPRODUCT(--(A1:A100="Corporate Marketing"),--(B1:B100="Critical"),C1:C100)
"Corporate Marketing" / "Critical" could be placed in cells and literals
replace by cell references.
Note SUMPRODUCT cannot reference whole columns.
HTH
"paula k" wrote:
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
how would I do this??
THANKS!!
|