How do I write a formula to tally class participation

Originally Posted by dilipandey

Hi gr8rcfan,

I would suggest you to upload a sample workbook with dummy results. Click on "go advanced" while replying and look for paper clip icon to upload the sample file.

Regards,
DILIPandey

<click on below 'star' if this helps>

Thank you, DILIPandey

I have attached a sample workbook as you suggested.

Speech.xls

The "Speech Competitions" tab shows the students appearing at each month's event
The "School Students" tab show what school each student comes from
The "School Points" tab shows each school (represented by a number) with the cells blow to be used to show the tally.

Thank you for any help you can provide

Guy