Multiple Count-IF

[Nick]

Hi,

I have the following data in three columns:

A B C
Dog Credit Man
Cat Cash Man
Dog Credit Woman

I would like to know how many Dogs were purchased using a
Credit card, by a Man?

TIA!

 

[Frank Kabel]

Hi
=sumproduct(--(A1:A100="Dog"),--(B1:B100="Credit"))

See for more:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Aladin Akyurek]

=SUMPRODUCT(--($A$1:$a$3=E1),--($B$1:$B$3=F1),--($C$1:$C$3=G1))

where E1 houses a value like Dog, F1 a value like Credit, and G1 a value
like Man.

For more on multiconditional counting (and summing), see:

http://www.mrexcel.com/wwwboard/messages/8961.html

 

[Bob Phillips]

Frank means

=sumproduct(--(A1:A100="Dog"),--(B1:B100="Credit"),--(C1:C100="Man"))


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Ludavhen]

Frank is definitly "the man" in excel, thus the formula should and will
work!

I am no expert, but a user. You may try using a pivot table selecting A, B,
and C as columns . and one of the colomns as data. This will allow you to
play arround with the data.

 

[Frank Kabel]

thanks for the correction