Max if???

[Denise B]

Hello,

I am looking for a max if statement if there is such a
thing. Same theory as sumif I just would like it to
return me the max number in that column for that category.

Any ideas?

Thank you,

Denise

 

[Norman Harker]

Hi Denise!

A bit sparse on the information but:

=MAX(A1:A20,0)

Provides the max of the entries in A1:A20 but not less than 0


--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Paul B]

Denise, try this

=MAX(IF((B2:B25="TEST"),A2:A25))

This is an array formula use (ctrl+shift+enter) to enter the formula

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[Guest]

Thank you....!!!!Perfect works great.

Denise

-----Original Message-----
Denise, try this

=MAX(IF((B2:B25="TEST"),A2:A25))

This is an array formula use (ctrl+shift+enter) to enter the formula

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **



.