Basic idea. Modify to suit and be sure to enter using ctrl+shift+enter
=MAX(IF(D1:D21="a",E1:E21))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Carrie_Loos via OfficeKB.com" <u34134@uwe wrote in message
news:8a94bcacb1ec5@uwe...
I can't figure out this array formula - can anyone assist?

Assume it is column A, B, C and row 2 starts the info I am reviewing. I
want
to find the maximum date for any value in column b that has a value
greater
than zero. The issue I am having is there are multiple months and multiple
people so a "SUMIF" type of formula would work but I can't figure out the
formula to do a "MAXIF" type of function. Any help would be greatly
appreciated. Thx Carrie

Example data:

Sum per line unique Date
AnthonyJan-08 0.0 01/01/08
AnthonyJan-08 0.0 01/02/08
AnthonyJan-08 0.0 01/03/08
AnthonyJan-08 0.0 01/04/08
AnthonyJan-08 0.0 01/05/08
AnthonyJan-08 0.0 01/06/08
AnthonyJan-08 0.0 01/07/08
AnthonyJan-08 0.0 01/08/08
AnthonyJan-08 0.0 01/09/08
AnthonyJan-08 0.0 01/10/08
AnthonyJan-08 0.0 01/11/08
AnthonyJan-08 0.0 01/12/08
AnthonyJan-08 0.0 01/13/08
AnthonyJan-08 0.0 01/14/08
AnthonyJan-08 0.0 01/15/08
AnthonyJan-08 0.0 01/16/08
AnthonyJan-08 2.0 01/17/08
AnthonyJan-08 2.0 01/18/08
AnthonyJan-08 2.0 01/19/08
AnthonyJan-08 2.0 01/20/08
AnthonyJan-08 2.0 01/21/08
AnthonyJan-08 2.0 01/22/08
AnthonyJan-08 0.0 01/23/08
AnthonyJan-08 0.0 01/24/08
AnthonyJan-08 2.0 01/25/08
AnthonyJan-08 2.0 01/26/08
AnthonyJan-08 2.0 01/27/08
AnthonyJan-08 2.0 01/28/08
AnthonyJan-08 0.0 01/29/08
AnthonyJan-08 0.0 01/30/08
AnthonyJan-08 0.0 01/31/08
AnthonyFeb-08 2.0 02/01/08
AnthonyFeb-08 0.0 02/02/08
AnthonyFeb-08 0.0 02/03/08
AnthonyFeb-08 2.0 02/04/08
AnthonyFeb-08 2.0 02/05/08
AnthonyFeb-08 0.0 02/06/08
AnthonyFeb-08 2.0 02/07/08
AnthonyFeb-08 2.0 02/08/08

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1