| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating cells with data
What is the formula to calculate total number of cells in row with
alphanumeric data in it? Thanks SRN |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating cells with data
=COUNTA(1:1)
-- Gary''s Student - gsnu200808 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating cells | Excel Worksheet Functions | |||
| Cells are not calculating on the fly | Excel Worksheet Functions | |||
| Inserting new data before "calculating cells" is done??? | Excel Discussion (Misc queries) | |||
| Calculating slope, intercept, LOGEST with empty cells in data | Excel Worksheet Functions | |||
| Calculating cells | Excel Discussion (Misc queries) | |||
Linear Mode
