| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question regarding the use of SUM in relation to text cells
I have a worksheet with 3 columns of cells, each cell with a name and address
in it. Down the left hand side there are area categories, like London or Leeds. I want to have a total at the bottom that displays the number of cells for each area. For example, it says Leeds on the left, then there are two names in column a, 1 in column b, and three in column c. I need a formula that I can put in a cell below this that will total the cells and display 6. anyone know if this is possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In relation to coding | Excel Programming | |||
| Question about parsing a column of cells with a comma in text | Excel Programming | |||
| Picking out a Period, in relation to certain cells | Excel Worksheet Functions | |||
| question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) | |||
| Conditional formatting in relation to other cells | Excel Worksheet Functions | |||
Threaded Mode
