Assume there was a space in the sheet name as you show...

=MAX('Sheet 1'!B2:B29)

If there aren't any spaces in the name of the sheet, then you don't need the
apostrophes....

=MAX(Sheet1!B2:B29)

--
Rick (MVP - Excel)


"Workbook" wrote in message
...
Thank you. It works great. Could I modify this formula so that if it was
in
Sheet 2 it would take data from Sheet 1?

"Gary''s Student" wrote:

=MAX(B2:B29)

no ifs are needed.
--
Gary''s Student - gsnu200832