This one doesn't required ctrl+shift+enter, Just press Enter

=SUMPRODUCT(MAX((A1:A20="T")*B1:B20))



"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