Don't Know What Funct to Use

  • Thread starter Thread starter bapple100
  • Start date Start date
B

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.
 
Hi

One way:
=SUMPRODUCT((C1:C4=1)*(A1:A4="x"))
and
=SUMPRODUCT((C1:C4=1)*(B1:B4="x"))
etc
 
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
 
Back
Top