=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!!