Hi everyone,

I am having trouble. Searched through threads and couldn't help me.

I have a table that has the following

Date Unit Type Max
10/01/2008 ZZ Associate 5
10/01/2008 AA Associate 10
10/02/2008 ZZ Holding 7
10/02/2008 ZZ Associate 4
10/02/2008 AA Holding 10
10/02/2008 ZZ Associate 15

What i am trying to do is say the following

If Date = 10/02/2008 and if Unit = ZZ and Type = Associate then give me the
max

So for 10/02/2008 - it would be 15

my formula so far (which i can't get is the following):

[=(MAX(IF(AND(A2:A65536=10/02/2008,B2:B65536="ZZ",N2:N65536="Associate"),G2:
G65536,""))))]

What is wrong.. Probably everything :)

Thanks everyone

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