Return a value based on two criteria

C

cdavidson

Column A contains various text (e.g. Player, Cut)
Column B contains numeric scores (e.g. -1, 0, 5, 6, 11, etc.)

All I want is a formula which will return the largest value from column B,
where column A contains the text 'Player'

Thanks for the assistance!
 
B

Bob Phillips

=MAX(IF(A1:A200="Player",B1:B100))

This is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top