=COUNTA(A:A) is neat and simple and returns the number of non-blank cells in column A. Is there something less ugly than:
=COUNTA(A1:XFD1) to get the equivalent number of non-blanks cells in row 1?
Ken
non-blank cells in a row
-
stuck
- Panoramic Lounger
- Posts: 8240
- Joined: 25 Jan 2010, 09:09
- Location: retirement
-
Rudi
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: non-blank cells in a row
How about:
=COUNTA(1:1)
=COUNTA(1:1)
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
stuck
- Panoramic Lounger
- Posts: 8240
- Joined: 25 Jan 2010, 09:09
- Location: retirement