View Single Post
  #6   Report Post  
dave roth
 
Posts: n/a
Default

Many thanks.

"Duke Carey" wrote:

=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.