Highest Value Between 3 Sheets

Closed
Report
Posts
1
Registration date
Tuesday November 3, 2015
Status
Member
Last seen
November 3, 2015
-
Needing help finding a formula/function to use for this situation:

I am holding a photo contest. There are 3 different types of photos people may turn in for this contest, so I have made 3 different worksheets to display scores. However, I want to see each person's HIGHEST photo score in one sheet at the end of my workbook so I can award the high-point winner quickly and easily.

I have tried to do a =MAX(sheet1:sheet3!:L2) function, but it tells me I have an error in the NAME? of the cells I have selected.

Any help????