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
how would I do this??
THANKS!!
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!!