Summing on 2 criteria

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top