Lottery spreadsheet

I run a lottery syndicate and have a very simple and pretty ineffective spreadsheet at present to account for monies paid in and winnings. I wonder if anyone has something I could copy to help me out on this. Basically I want to show all participants and the amount they have paid each week, then somehow when we win anything spread that evenly between everyone who paid so that if someone leaves down the line we know how much they are owed.

I've attached what I have but it doesn't work when e.g. £50 is split by 24 people (last but one tab).

Thank you very much in advance!

Beacuse your SUM in M31 sum =SUM(M3:M29) instead of =SUM(M3:M30)

Is that it?

Thanks so much - I do feel like a bit of a tool now!!!

Time for coffee

Hi this is part of one I used some time ago so see if it meets your requirements