Count cells every 12th column
Here is an attempt to show you what the spreadsheet looks like:
6/1 6/2
Male Female
Male Female
Under 18 1 0
3 5
18-34 2 4
5 2
35-63 10 15
4 2
63 and up 11 11
6 12
Total per day 54 39
I am looking to make a formula which would deal with the "total per
day" row. I need to have it count every 12th cell & be able to give it
a different starting point for each day calculation, because this
would allow it to count up all the Saturday totals, all the Monday
totals, etc, etc, etc.
|