a couple of comments in 2003 or earlier you cant use Q:Q as a shorthand in
Sumproduct
Q$1:Q$64000
=SUMPRODUCT(--('WaitTimes'!Q$1:Q$64000=Sheet1!A2),--('WaitTimes'!H$1:H$64000="1),--('WaitTimes!G$1:G$64000="B),--(M$1:M$64000=max(M$1:M$64000)),M$1:M$64000)

"jhicsupt" wrote:

Trying to get the maximum date in column M if criteria met:

=SUMPRODUCT('WaitTimes'!Q:Q=Sheet1!A2,'WaitTimes'! H:H="1)",'WaitTimes!G:G="B",??? I need to add the maximum date in column M)???

I'm trying to figure out how to get the maximum date in column M if all of
the criteria is met -- can you help me?

Thanks in advance.