| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
average of visible cells in a filtered range
Good Afternoon:
I need to average only the visible cells in a range which has been filtered, i.e. =SUMPRODUCT(--(InjuryType1_2005="Gunshot"),--(Age_2005<0)). I now want to average the age of the victims. I've tried several functions, including =Average(sumproduct....), =SUMPRODUCT(--(InjuryType1_2005="Gunshot"),--(Age_2005<0))/COUNTIF(Age_2005,"<0"), and some others. TIA for your assistance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| Visible cells | Excel Worksheet Functions | |||
| Strange Problem with Chart and Plot Visible Cells Option | Charts and Charting in Excel | |||
Threaded Mode
