Hello all, hope you can help.
I am having difficulty with a AVERAGEIFS formula I am currently using.
When I use filters and highlight the range that applies, excel provides to correct average calculation in the bottom RHS of the window.
However when I use the formula below it returns a...