Lacan
Active Member
- Joined
- Oct 5, 2016
- Messages
- 253
- Office Version
- 365
- Platform
- Windows
Hi Guys, 🖐
Would like your help to discover formula to calculate average only if values are proximate, equal or higher of the average value result?
All the help are very welcome.
Thank you very much!
Would like your help to discover formula to calculate average only if values are proximate, equal or higher of the average value result?
All the help are very welcome.
Thank you very much!
Fórmula Principal para o Ficheiro VDF.xlsm | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
1 | ||||||||||||||||||
2 | NAMES | ENE. 2025 | FEB. 2025 | MAR. 2025 | ABR. 2025 | MAY. 2025 | JUN. 2025 | JUL. 2025 | AGO. 2025 | SEP. 2025 | OCT. 2025 | NOV. 2025 | DIC. 2025 | AVERAGE RESULT | ||||
3 | JOHN | 2 | 2 | |||||||||||||||
4 | ANNA | 5 | 100 | 5 | 5 | 10 | 5 | 22 | ||||||||||
5 | LISA | 10 | 4 | 3 | 50 | 3 | 3 | 7 | 8 | 7 | 4 | 10 | ||||||
6 | MARIE | 2 | 50 | 50 | 2 | 3 | 21 | |||||||||||
7 | ROB | 1 | 2 | 3 | 4 | 100 | 8 | 8 | 8 | 17 | ||||||||
8 | ||||||||||||||||||
9 | ||||||||||||||||||
AVERAGE |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2:N2 | C2 | =TRANSPOSE(UPPER(TEXT(EDATE("01-01-2025",SEQUENCE(12,1,0)),"[$-es-ES]mmm aaa"))) |
O3:O7 | O3 | =AVERAGEIFS(C3:N3,C3:N3,">0") |
Dynamic array formulas. |