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

I've already figured out the formula to count the different age groups
and genders. Now what I need is a formula to count the total visitors
per day, but end up with totals for all Mondays, Tuesdays, Wednesdays,
etc....... my ultimate end goal is to be able to get an average number
of visitors for each day of the week.

On Jul 1, 4:38 pm, "Bob Phillips" wrote:
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

This was resolved in a cross-post on the programming forum:
http://groups.google.com/group/micro...4503966a08c04#

Thanks for the ideas!