delfinpedro
New Member
- Joined
- Sep 24, 2018
- Messages
- 15
- Office Version
- 2016
- Platform
- Windows
Good day, Im a little experienced with tables and have no issues with single sum or average ranges. Even dynamic, etc. Now I´m trying to average 2 columns based on criteria:
=AVERAGEIFS(AMR[[#All],[2001Jan]:[2002Feb]],AMR[[#All],[Act]],[@Act]) It´s returning #VALUE!
I have no issues with single column average range, =AVERAGEIFS(AMR[[#All],[2002Feb]:[2002Feb]],AMR[[#All],[Act]],[@Act])
Once I now how to have 2 columns I{ll include more criteria and include variables. So pls use averageifS I have similar issue with sumifs by the way.
Thx a lot.
=AVERAGEIFS(AMR[[#All],[2001Jan]:[2002Feb]],AMR[[#All],[Act]],[@Act]) It´s returning #VALUE!
I have no issues with single column average range, =AVERAGEIFS(AMR[[#All],[2002Feb]:[2002Feb]],AMR[[#All],[Act]],[@Act])
Once I now how to have 2 columns I{ll include more criteria and include variables. So pls use averageifS I have similar issue with sumifs by the way.
Thx a lot.