Would also be a good idea to share a spreadsheet with some dummy data, you could lay the data out as you have it currently. Members here will be more likely to assist if they don't have to recreate your scenario.
As Aussie has pointed out above, I am sure this could be done with formula, this would allow for your stats to update with future data being added.