Thread
:
sumproduct - Need maximum date returned
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
sumproduct - Need maximum date returned
Here is the idea where checksD has your dates and the others are the
conditions. Modify to suit and array enter (ctrl +shift+enter)
=MAX(IF(ChecksA=M1,ChecksA<N1,ChecksD))
--
Don Guillett
SalesAid Software
"jhicsupt" wrote in message
...
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett