max function with condition

S

shaji

I have a range of data. In column A is Dates, in column B is amounts. I want
to find the maximum amount in each day in another column for calculating
interest. Can anyone provide me a function for the same.

Thanks in advance
 
B

Bob Phillips

=MAX(IF(B2:B200=--"2006-07-10",B2_B200))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
A

Ardus Petus

Ooops: I think you meant
=MAX(IF(B2:B200=--"2006-07-10",C2:C200))
(fastest typist east of Colorado)

Cheers,
 
B

Bob Phillips

Thanks Ardus. I did mean colon

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top