Summing fields on dual or more critiera fields

[Guest]

Thanks once again to Frank Kabel for providing the best information to be had. I ask him the following question

So with that aside here is my dilema


Col A (Male or Female








Col B (Subscription Type








And i've added a count column (Col C







What i need is a sumif that looks up from A1:A6,"M" and then looks B1:B6,"1",C1:C

This is for user registration on my site and I need to know % of males and females and what subscription type they have
So what I'm trying to say is i need to sum all the M's with 2's and all the F's with 4's etc etc. A dual SUMIF function if you will

AND here is his response which I must say as always works beautifully Thanks a million Frank

tr
=SUMPRODUCT((A1:A6="M")*(B1:B6=2),C1:C6

 

[Frank Kabel]

Hi
thanks for your feedback

--
Regards
Frank Kabel
Frankfurt, Germany

Thanks once again to Frank Kabel for providing the best information

to be had. I ask him the following question:

So with that aside here is my dilema.


Col A (Male or Female)
M
F
F
M
M
F
M

Col B (Subscription Type)
1
2
2
3
4
2


And i've added a count column (Col C)
1
1
1
1
1
1

What i need is a sumif that looks up from A1:A6,"M" and then looks B1:B6,"1",C1:C6

This is for user registration on my site and I need to know % of

males and females and what subscription type they have.

So what I'm trying to say is i need to sum all the M's with 2's and

all the F's with 4's etc etc. A dual SUMIF function if you will.