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