COUNTIF Formula problems

L

LDanix

I am trying to get a count of a few cells. I just need them to be counted if
they are greater than 0. I have tried two different ways and both give me an
error. Here's what I have tried:

=COUNTIF((E6,N6,AI6,AL6,AO6),">0")
and
=COUNTIF(E6+N6+AI6+AO6+),">0"

Any help would be greatly appreciated.
 
M

Martin P

You will have to write it as
=COUNTIF(E6:AO6,">0")

If you insist on the intermediate cells not being included, I suggest
=COUNTIF(E6,">0")+COUNTIF(N6,">0")+..., but in that case I think there are
better options.
 
Top