=subtotal(1,age column)
will work on (average) only the visible cells
"dave roth" wrote:
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.
|