creative999
Board Regular
- Joined
- Jul 7, 2021
- Messages
- 85
- Office Version
- 365
- 2019
- Platform
- Windows
- MacOS
How do i get multiple criteria in same column (column A) to work with averageif... example:
=AVERAGEIFS(Z2:Z500,P2:P500,"<>NEW",A2:A500,"APPROVED",A2:A500,"TEMPAPPROVED")
=AVERAGEIFS(Z2:Z500,P2:P500,"<>NEW",A2:A500,"APPROVED",A2:A500,"TEMPAPPROVED")