I have a worksheet
 

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.

I have a worksheet
 

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

On Nov 18, 11:07*am, Skip wrote:
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.