MAX IF?
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
|