Don't Know What Funct to Use

[bapple100]

I have 3 columns A-B-C


A B C
1 x 1
2 x 1
3 x 2
4 x 3

I want to count number of x's in range A1:A4 that also have a value of
1 in coulmn C.

Same for range B1:B4 - I want to count the number of x's that have a
value of 1 in column C

I basically want to repeat this for the range A1:A4 - I want to count
the number of x's that have a value of 2 in column C etc

Does anyone have any suggestions? The x in colums A and B signify very
different things so they must be reported seperately.

 

[Andy B]

Hi

One way:
=SUMPRODUCT((C1:C4=1)*(A1:A4="x"))
and
=SUMPRODUCT((C1:C4=1)*(B1:B4="x"))
etc

 

[JulieD]

Hi

one option

=SUMPRODUCT((A1:A4="x")*(C1:C4=1))
=SUMPRODUCT((A1:A4="x")*(C1:C4=2))

etc for the rest of your question

Cheers
JulieD