Max if???

D

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
 
N

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
P

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 **
 
G

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 **



.
Click to expand...
 
Top