| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count a number range and a letter in a cell
Anyone help? I need to have a running total of numbers and text in the same
cell onto another sheet and cell. e.g 74M, 80M will total in a cell Male 70+. 56F, 40F will total in a cell Female 39-60, any ideas for a formula for this, I can get the cell to recognise the ages, also recognise whether text is M or F but cant get the cell to recognise both as text 74M. info in cell is input as AGE then sex. e.g 76M, 50F |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Determines Number of Cell in Formula Range | Excel Worksheet Functions | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Formula to count number of days in range which are less than today | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Threaded Mode
