ExcelBanter - tally

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - tally (https://www.excelbanter.com/excel-worksheet-functions/9226-tally.html)

Stan Altshuller

tally

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"),"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!

All times are GMT +1. The time now is 03:01 AM.