sumproduct - Need maximum date returned
It returns 01/00/00
"T. Valko" wrote:
Try this array** formula:
=MAX((WaitTimes!G1:G10="B")*(WaitTimes!H1:H10=1)*( WaitTimes!Q1:Q10=Sheet1!A2)*WaitTimes!M1:M10)
Format the cell as DATE
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
Also note that you *can't* use entire columns as range references unless
you're using Excel 2007
Biff
"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.
|