calculating cells with data
 

What is the formula to calculate total number of cells in row with
alphanumeric data in it?

Thanks

SRN

calculating cells with data
 

=COUNTA(1:1)
--
Gary''s Student - gsnu200808

calculating cells with data
 

What is the formula to calculate total number of cells in row with
alphanumeric data in it?

And if there's the possibility of formula returned blanks: "" within the
range, and pure white spaces: " " which are to be excluded from the count,
you could use something like this:
=SUMPRODUCT(--(TRIM(A2:A10)<""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---

calculating cells with data
 

Max

That worked perfectly. I did have blank cells that had to be ignored

Thanks

SRN

"Max" wrote:

What is the formula to calculate total number of cells in row with
alphanumeric data in it?

And if there's the possibility of formula returned blanks: "" within the
range, and pure white spaces: " " which are to be excluded from the count,
you could use something like this:
=SUMPRODUCT(--(TRIM(A2:A10)<""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---

calculating cells with data
 

Welcome ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500, Files:362, Subscribers:62
xdemechanik
---
"SRN" wrote in message
...
Max

That worked perfectly. I did have blank cells that had to be ignored

Thanks

SRN