I'm not entirely sure that title is as clear as I intend. In any event, I'm trying to do an AVERAGEIFS based on several criteria - all of which entail an AND/OR. These formulas are on the 'Data' tab and the criteria are on the 'Position' tab. Using these criteria I want to average the salaries found on the various other tabs (4-30-19, 5-31-19, etc).
So average the salary if it's in Job 1 (which is one of several jobs on a different tab) AND if it's in Loc 1 (which is one of several locations on a different tab).
Right now my formula doesn't work, it's: {=AVERAGEIFS(INDIRECT("'"&$K$3&"'!$G:$G"),INDIRECT("'"&$K$3&"'!$C:$C"),Position!$A$2:$A$3,INDIRECT("'"&$K$3&"'!$E:$E"),Position!$A$10:$A$11)}
Which gives me 100,000, which is not correct - it should give me 137500.
I haven't been able to find something online that's precisely like this.
Any help is appreciated.
Bookmarks