Forum Discussion
cmdo04
Jan 21, 2019Copper Contributor
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 ar...
Naveen1992
Jan 21, 2019Brass Contributor
Hi cmdo04
use averageif formula.
| W1 | W2 | W3 | W4 | avg. | W1 | W2 | W3 | W4 | W5 | avg. |
| 50 | 23 | 34 | 6 | 35.67 | 30 | 21 | 9 | 10 | 3 | 25.50 |
| AVERAGEIF(A2:D2,">10") | AVERAGEIF(F2:J2,">10") |
regards,
Naveen