calculating cells with data

  • Thread starter Thread starter SRN
  • Start date Start date
S

SRN

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

Thanks

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

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
---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the =page! feature to transpose a row to column 0
Loop with Leban's code to merge 3+ reports to one PDF file 0
MYSTERY: NESTED INDEX AND MATCH FUNCTIONS 29
hidden rows problem 7
how to do data validation in excel 1
Scrabble Value calculation for Welsh words 0
cell reference of a formula 2
Why won't target cell data changes trigger formula evaluation? 3

Back
Top