Countif(Not blank)
 

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

Countif(Not blank)
 

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

Regards,
Fred.

"David" wrote in message
...
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

Countif(Not blank)
 

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

Countif(Not blank)
 

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


"David" wrote in message
...
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