How to use countif with more than 3 ranges?

[CANNONT4]

Hi there,

I am trying to count how many times "2b" appears in 9 seperate ranges, like this for example:

=COUNTIF(H4:H19,J4:J19,L4:L19,N4:N19,N4:N19,P4:P19,R4:R19,T4:T19,V4:V19,X4:X19"2b")

It says I have too many arguments and would appear to allow me to count up to only 3 data ranges. Any ideas how to fix this?

Many thanks,

Tom.

 

[Sektor]

COUNTIFS

 

[earthworm]

Try this

Book1
	A	B	C	D	E	F	G	H	I	J
2	2B	1	2	3	4	5	6	7	8	9
3	6	2B	2B	2B	2B	2B	2B	2B	2B	2B
4		2B	2B	2B	2B	2B	2B	2B	2B	2B
5		2B	2B	2B	2B	2B	2B	2B	2B	2B
6		2B	2B	2B	2B	2B	2B	2B	2B	2B
7		2B	2B	2B	2B	2B	2B	2B	2B	2B
8		2B	2B	2B	2B	2B	2B	2B	2B	2B
Sheet1

Cell Formulas
Range	Formula
A3	A3	=COUNTIFS(B:B,$A$2,$C:$C,$A$2,$D:$D,$A$2,$E:$E,$A$2,$F:$F,$A$2,$G:$G,$A$2,$H:$H,$A$2,$I:$I,$A$2,$J:$J,$A$2)

 

[CANNONT4]

COUNTIFS

Cheers for the input, however I really am a novice and I can't get my head around that! I've now tried:

=COUNTIFS(H4:H19,"2b",J4:J119,"2b",L4:L19,"2b",N4:N19,"2b")

and its coming up with #value! error.

I am lost.

 

[CANNONT4]

Here's my sheet, this formula is now not throwing up an error but is just displaying 0, when there are clear '2b's in the cells.

 

[Tivakaran]

Here's my sheet, this formula is now not throwing up an error but is just displaying 0, when there are clear '2b's in the cells.

remove the equal sign in "=2b"

 

[CANNONT4]

remove the equal sign in "=2b"

Thank you, but still chucking up zero!

 

[Tivakaran]

try =COUNTIF(H4:X19,"2b")
and let me know ya

 

[Tivakaran]

oh ya...wh

Thank you, but still chucking up zero!

y your COUNTIFS didnt work is because COUNTIFS is for multiple crtiteria...not multiple cell

 

[CANNONT4]

try =COUNTIF(H4:X19,"2b")
and let me know ya

That identifies 2 counts of 2b.