Thread: average of visible cells in a filtered range
View Single Post
  #5   Report Post  
Ola
 
Posts: n/a
Default
This is one option
=AVERAGE(IF((InjuryType1_2005="Gunshot")*(Age_2005 <0),Age_2005))

Confirm the Array-formula with Ctrl + Shift then hit Enter

Hope it helped
Ola Sandström

Reply With QuoteReply With Quote