Countif(Not blank)

[David]

Trying to count cells in the indicated cell that are not blank. This is what
I tried, but it still counts blank cells.

=(COUNTIF(AB4,"<>""")+COUNTIF(AG4,"<>""")+COUNTIF(AL4,"<>""")+COUNTIF(AQ4,"<>"""))

Thanks

 

[Fred Smith]

Just use "<>" rather than "<>"""

Regards,
Fred.

 

[Teethless mama]

Try this:

=SUMPRODUCT(--(MOD(COLUMN(AB4:AQ4),5)=3),--(AB4:AQ4<>""))

 

[Tyro]

To work, your formula would have to be

=COUNTIF(AB4,"<>"&"")+COUNTIF(AG4,"<>"&"")+COUNTIF(AL4,"<>"&"")+COUNTIF(AQ4,"<>"&"")

However, as Fred said, you can use the simpler

=COUNTIF(AB4,"<>")+COUNTIF(AG4,"<>")+COUNTIF(AL4,"<>")+COUNTIF(AQ4,"<>")

Note that there is no need for parentheses around the whole formula

Tyro