tami

Try an array formula like

=MAX(--(A1:A9="T")*(B1:B9))

use shift-control-enter to enter. This will give the max value for
numbers in B1:B9, where A1:A9 has the letter T.

Good luck

Ken
Norfolk, Va

On Jun 30, 3:46*pm, 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