DCOUNT

[Carlo]

I'm battling to understand DCOUNT. What I am trying to do is have say:
a b c d e
1 2 3
2 2 4 5
3 1 2
4 1
5 1 2

have a formula that will say that there are 4 "2's" in the list

Please help
Thanks
carlob1

 

[Frank Kabel]

Hi
try
=COUNTIF(A1:E5,2)