View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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