Multiple Count Criteria Formula

I have a sheet with 4 headings - Name, Appointments, Sales, Revenue

I need to have a table at the side with a count of each persons results. I have counted the appointments by simply counting the amount of times the persons name occurs.
Now I don't know how to count the sales and revenue associated with that person.

What I would like help with is like this

Name Sale Rev
A Y 500
B N 0
A N 0
C Y 650
B Y 320

I need to total the amount of sales per person where Y = 1 sale and then add the associated revenue.

Any help would be greatly appreciated.

Thank you

Hello
Try something like this
=SUMIFS(C1:C5,A1:A5,"A",B1:B5,"Y")
where A column is name B is Y or N and C is revenue

You can change the formula like this for B
=SUMIFS(C1:C5,A1:A5,"B",B1:B5,"Y")

Tell me if it works right….

Hope it helps
Do ask for any other query you may have…

If you feel that someone spent time on solving your problem then you can mark the thread as “SOLVED” (by going to thread tools at the top and clicking on “mark this thread as solved”) can just click on ADD REPUTATION below the posts to say thanks...
Regards
Sourabh Gupta

Thank you Sourabh. This has worked for the revenue column. I still can't show the volume of sales per person in the sales column. This would mean counting "Y" against the name. Hope this makes sense.