View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] tours@aldoleopold.org is offline
external usenet poster
 
Posts: 7
Default 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.