Forum Discussion

cmdo04's avatar
cmdo04
Copper Contributor
Jan 21, 2019

Average computation that ignores cells with formula and less than values

Hi!

I'm currently working on a score tracker where I input a number/score per week. At the end of the month, I need to get the weekly average but valid scores than can be included in this average are only those values from 10 pts and above. (Please note that I would still need to reflect values less than 10 in the report). The same is done on the following month. 

Now at the end of the year, I would also need to reflect a weekly average taking into account all weeks with scores above 10 pts.

 

How do compute for the weekly average of the entire row but excluding 1) all cells with formulas (monthly ave.) and 2) all cells with values less than 10?

 

  • Naveen1992's avatar
    Naveen1992
    Brass Contributor

    Hi cmdo04

     

    use averageif formula.

     

    W1W2W3W4avg.W1W2W3W4W5avg.
    502334635.673021910325.50
        AVERAGEIF(A2:D2,">10")     AVERAGEIF(F2:J2,">10")

     

    regards,

    Naveen

Resources