AND function using COUNTIF
 

I would like to count entries in column "B" that equal a criteria and also
meet a criteria in column "A".

For EX:

If entry in column "A" equals "Walt" and entry in column "B" equals "x" then
count

Note: I think I had a solution a few years ago that used the -- function.

Please help me solve this again.

Thanks

AND function using COUNTIF
 

=SUMPRODUCT(--(A2:A200="Walt"),--(B2:B200="x"))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Walter L. skinner" wrote in
message ...
I would like to count entries in column "B" that equal a criteria and also
meet a criteria in column "A".

For EX:

If entry in column "A" equals "Walt" and entry in column "B" equals "x"
then
count

Note: I think I had a solution a few years ago that used the -- function.

Please help me solve this again.

Thanks

AND function using COUNTIF
 

Hi Walter,

You could try something like this..


=SUMPRODUCT(--(A1:A1000="Walt"),--(B1:B1000="X"))

Hope this helps,

Gav.

"Walter L. skinner" wrote:

I would like to count entries in column "B" that equal a criteria and also
meet a criteria in column "A".

For EX:

If entry in column "A" equals "Walt" and entry in column "B" equals "x" then
count

Note: I think I had a solution a few years ago that used the -- function.

Please help me solve this again.

Thanks

AND function using COUNTIF
 

=sumproduct((a2:a22="Walt")*(b2:b22="x"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Walter L. skinner" wrote in
message ...
I would like to count entries in column "B" that equal a criteria and also
meet a criteria in column "A".

For EX:

If entry in column "A" equals "Walt" and entry in column "B" equals "x"
then
count

Note: I think I had a solution a few years ago that used the -- function.

Please help me solve this again.

Thanks

AND function using COUNTIF
 

=SUMPRODUCT((A1:A100="Walt")*(B1:B100="x")) or
=SUMPRODUCT(--(A1:A100="Walt"),--(B1:B100="x"))
--
David Biddulph

"Walter L. skinner" wrote in
message ...
I would like to count entries in column "B" that equal a criteria and also
meet a criteria in column "A".

For EX:

If entry in column "A" equals "Walt" and entry in column "B" equals "x"
then
count

Note: I think I had a solution a few years ago that used the -- function.

Please help me solve this again.

Thanks