| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding 1 everytime something is in a column
I have an empty column that I fill with numbers that could be 2, 30, etc.
( from A1 to A40). In A41 I like to have a total of cells with numbers on it ( not the sum ), in other words, A41=total of cells filled from A1 to A40. Thanks in advance for the formula ( no VBA please ). -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000: Adding column D based on value in column A | Excel Worksheet Functions | |||
| Adding a Custom Column based on an existing Column (EXPERT) | Excel Worksheet Functions | |||
| Insert A blank Row Everytime the date changes in column B | Excel Discussion (Misc queries) | |||
| how to get an equation to update everytime a column is inserted? | Excel Discussion (Misc queries) | |||
| Entering a row everytime column C changes value | Excel Discussion (Misc queries) | |||
Threaded Mode
