| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic Percentage issue: HELP!!!
Hi, got a problem with the following:
I want to find the percentage of cells that are greater than 24 in a collumn out of all the cells in the collumn that have an entry (some will be blank) . Then I want to do the same but only for the cells that satisfy a pervious requirement from an earlier collumn eg "Female". SUMPRODUCT((E10:E89="Female")*(GD10:GD8924))/SUMPRODUCT((E10:E89="Female")*(GD10:GD890)) Would this work??? Thanks RR1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage Issue | Excel Discussion (Misc queries) | |||
| basic question - how to calculate a cumulative percentage? | Excel Worksheet Functions | |||
| Basic question - how to calculate a cumulative percentage | Excel Discussion (Misc queries) | |||
| Another Visual Basic/Dependant Cells issue | Excel Worksheet Functions | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Threaded Mode
