Creating formula

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

I want to create a formula so I can check if values in
column AC (cells 4-846) are above 60. If yes, I want to
use the cells in the corresponding rows from column H to
obtain an average. In other words I want an average from
column H only using the cells whose corresponding value in
column AC is 60 or above. Thank You!
 
Hi Heather
one way:
=SUMIF(AC4:AC846,">60",H4:H846)/COUNTIF(AC4:AC846,">60")
HTH
Frank
 
Back
Top