I have a worksheet

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

 

[Pete_UK]

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