| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for running total
I need a formula to the following. 74M, 70M, 86M. a formula to recognise the
number and text of the cell and get a total from another cell which has a total of the following Male age 70+ (3), I can get the formula to recognise the numbers and the letter seperately but cant get a formula to recognise both to put them in proper cells for age male, age female. The formula i'm using is the following =COUNTIF(Interventions!C19:C81,"70") I need to integrate M or F into this to list Male and Female over 70. Can anyone help me???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the formula to convert time (3:46) to total seconds? | Excel Worksheet Functions | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| Formula to sum total numbers with dashes in them | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Linear Mode
