Here is one way

=IF(COUNTIF(B2:E2,"buy")COUNTIF(B2:E2,"sell"),"bu y",IF(COUNTIF(B2:E2,"buy")
<COUNTIF(B2:E2,"sell"),"sell",""))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stan Altshuller" wrote in message
...
I have 100+ funds with ratings from different managers that I need to
summarize across each fund.
so
manager 1 manager2 ...
fund 1 buy sell ....

i need the last column to display the "average" rating. is it possible?
THANKS!