tally

[Stan Altshuller]

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!

 

[Bob Phillips]

Here is one way

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

--

HTH

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