Try this:

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


"David" wrote:

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