I have a worksheet

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

with columns of data. (50-100 columns). After the data is entered, is
there a formula that will count the number of
columns I have. Some are negative, some positive, and occasionally a
zero is used. I need to know the total for
other calculations in my worksheet. I am currently counting the
columns manually. Thanks for any help.
 
Have you tried using COUNT? For example:

=COUNT(2:2)

will count all the columns that have numbers in them in row 2, and
will ignore empty cells and cells containing text. Put the formula on
a different row.

Hope this helps.

Pete
 
Back
Top