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
|