This formula helps to count only cell with values in the given range. It will exclude blank cells.
=Counta(range)
Range= Area/ Range to count
No comments:
Post a Comment