S
SRN
What is the formula to calculate total number of cells in row with
alphanumeric data in it?
Thanks
SRN
alphanumeric data in it?
Thanks
SRN
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
=COUNTA(1:1)
M
Max
What is the formula to calculate total number of cells in row with
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
---
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
---
S
SRN
Max
That worked perfectly. I did have blank cells that had to be ignored
Thanks
SRN
That worked perfectly. I did have blank cells that had to be ignored
Thanks
SRN
M
Max
Welcome ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500, Files:362, Subscribers:62
xdemechanik
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500, Files:362, Subscribers:62
xdemechanik