COUNTIF for two criterias

[dterest]

Hello,

I would like to use the countif function but using two criterias.
For example:

I want to count the times the string X appears on column B for
certain criteria in column A.

A B

1 X
1
1 X
1 X
1
2 X

In this case I would like to count the X's matching the value in colum
A = 1, the result should be 3.
Does anyone know, how to do this?
Thanks in advance for any help

 

[Guest]

Use SumProduct(b1:B10,=x)*(A1:A10=1)

 

[Amy Cox]

Hi,

This is an array formula and would need to be entered as
follows:

=SUM((A1:A10=1)*(B1:B10="x"))

Since this is an array formula rather than hitting enter
once you have completed the formula you must press
Ctrl+Shift+Enter.

Good luck!
Amy Cox
Replacements, Ltd.
1-800-REPLACE

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A100=1),--(B1:B100="X"))

 

[Frank Kabel]

Hi
you probably meant:
SumProduct((B1:B10="X")*(A1:A10=1))

(corrected some typos and missing brackets)

 

[DNF Karran]

Try

=SUMPRODUCT(--(A1:A10=2),--(B1:B10="x"))

Dunca

 

[dterest]

Thank you everyone!! It was very helpful!