MAX IF?
Try this array formula
=MAX(IF(A1:A20="t",B1:B20))
This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array
Mike
"Tami" wrote:
can i write a formula that takes the max value in column B but only if column
A has "T" in it...like a SUMIF....
thx.
tami
|