Creating formula

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!
 
F

Frank Kabel

Hi Heather
one way:
=SUMIF(AC4:AC846,">60",H4:H846)/COUNTIF(AC4:AC846,">60")
HTH
Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top