{=MAX(IF('2010:2014'!B:B=A2,'2010:2014'!C:C))}
I am entering with CTRL-Shift-Enter and this formula isn't working.
If I remove the IF statement this formula works. With it, however, will give me a #REF error. But I need the IF because I'm trying to determine the MAX of a specific criteria over time.
I've attached my spreadsheet and you can find this formula in K7 of the 'Scoring Records' tab.
One other question... the MAX formula allows for multiple criteria but is there a way to put it without entering the entire formula a second (or third) time beyond a comma?
I would like to remove the ALL tab, that's why I'm trying to do this across multiple sheets.
Bookmarks