Count '*' (asterisk) as a number

[sirdon]

Hi all

I have attached a file showcasing what I have done. Below is what I am trying to do.

For "worksheet - overall_batting_statistics, Column - C" i need it to count '*' (asterisk) as a number from "worksheet - Trial001, Column E24:E38 and E49:E63"

Please let me know if you need me to explain in further detail.

Many thanks,

[FDibbins]

sirdon, how is this thread any different from...
http://www.excelforum.com/excel-form...est-score.html

If they are different, please explain how. If they are not different, please do not post duplicate threads

[sirdon]

sorry. I was just trying to separate the threads from the 2 points. I should have originally done it this way in the first place. I do apologies. Feel free to delete either thread.