I want to average all cells in a row based on the day of the week in another row and I only want it to include cells greater then 0. Essentially for the average returned in R2, the range is A2:N2, if A1:N1 is Sunday, return average for sundays and only include in the average if cell in row 2 is >0. I know this was a complicated explanation, but the best way I could tink to explain it.
<tbody>
</tbody>
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
1 | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | DAY | AVG | ||
2 | 119 | 36 | 236 | 246 | 255 | 254 | 248 | 116 | 33 | 241 | 252 | 265 | 262 | 254 | Sun | |||
3 | Mon | |||||||||||||||||
4 | Tues | |||||||||||||||||
5 | Wed | |||||||||||||||||
6 | Thur | |||||||||||||||||
7 | Fri | |||||||||||||||||
8 | Sat |
<tbody>
</tbody>