COUNT entire row

  • Thread starter Thread starter nws_reader
  • Start date Start date
N

nws_reader

I've searched and couldn't find an answer.
I want to use COUNT(range) where my range is the entire row or all the
columns starting at C1.

COUNT(C1:???)
 
I don't remember, there are 16384 columns I believe. Personally I think 256
columns are too many
I have never designed a sheet that comes even close in having the number of
columns of 2003.
 
It's XFD.

Maybe
=COUNT($1:$1)-COUNT(A1:B1)
to account for both scenarios.
 
You must log in or register to reply here.

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

Excel VBA - counting cells by colors and names to it in two different rows. 0
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Counting Merged Cells 6
Counting NON-Blank fields 2
Applying Max Conditonal Formatting to an entire row when condition 2
Count Max values in a range 6
Count the number of a range of words in a cell 9
Count and Sum of cells if conditions fulfilled 12

Back
Top