"Bob Phillips" wrote:

=MAX(IF(PosterRange="Margo",DateRange))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Hrm that works.... Finally figured out it wasnt the forumla the one range
was misdefined. that would mess it up I suppose.

Thanks