Hi, I have a formula that's supposed to count only if the cell doesn't include a "0" or a blank.
=COUNTIF(A1:G1,AND("<>0","<>"""))
The row looks like this
A B C E F G
1 0 0 2 3
This formula doesn't work. Can someone please help?
Many thanks in advance.
=COUNTIF(A1:G1,AND("<>0","<>"""))
The row looks like this
A B C E F G
1 0 0 2 3
This formula doesn't work. Can someone please help?
Many thanks in advance.