Summing on 2 criteria

  • Thread starter Thread starter Reggie
  • Start date Start date
R

Reggie

I'm simply trying to add values in a third column if the
values in the 1st two columns meet my demands.

a b c

bob mary 10
bob susy 9
mark jan 15
steve bambi 12
jon carly 8
bob mary 27

I want to ask for a total of column c where a=bob AND
b=mary. In this case, the answer would be 37.

PLEASE - how can I do this?
 
Back
Top