Averageif and AND functions
I am lost and could really use some help. I am attempting to build a formula in the Sheet Summary to capture the Average Throughput of changes that are set with a particular Change Priority, Quarter, and Year. The formula I have is:
=AVERAGEIF(Throughput:Throughput, AND([Change Priority]:[Change Priority] = "Critical", [Closed Quarter]:[Closed Quarter] = "Q4", [Closed Year]:[Closed Year] = "2021"))
The above formula is returning #Invalid Operation. I will also add, you may be able to rule out any blank fields causing the issue. The sheet is set so that if the change is still OPEN, no data populates in the fields I am referencing.
I am sure I am not fulling understanding how to use the AND function and that may be the issue. All guidance is welcomed!
Thank you ~Marlayna
Help Article Resources
Check out the Formula Handbook template!