Count cells every 12th column
Well I see the data okay now, but have no idea what you are trying to count.
Your so-called age labels are One, Two, Three, Four. Is One 17 and under,
Two 18-34, etc.?
Are you just trying to sum all male visitors for One, Two, etc.? If so, just
use
=SUMIF($4:$4,"M",5:5)
=SUMIF($4:$4,"F",5:5)
and so on
--
__________________________________
HTH
Bob
wrote in message
...
Sorry, the spreadsheet description post didn't work very well.
I have tried the MOD(...,12) and when I checked it, the figure was
incorrect. So there must be something wrong.
Let me try a screen shot:
<a href="http://www.flickr.com/photos/jenkob/2628527135/"
title="screen"<img src="http://farm4.static.flickr.com/
3074/2628527135_911b2e2e82_b.jpg" width="1024" height="640"
alt="screen" /</a
|