Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions |