I need a formula the counts the number of cells that meet 2 conditions ac multiple w/sheet

I am trying to count the number of male and female clients of each age from 11-25 across multiple worksheets.

This sounds simple, and probably is for someone experienced, but I am an Excel novice and I'm struggling.

On all worksheets B6 contains the age and D6 contains M or F.

Excel is not very good at 3-D references, as many functions do not work with them. I would suggest that you have a formula in the same cell (eg. X1) in each of your worksheets like this:

=COUNTIFS(D:D,"M",B:B,">=11",B:B,"<=25")

which will count the number of males aged between 11 and 25 (inclusive) on that sheet. You can have a similar formula in X2 for females:

=COUNTIFS(D:D,"F",B:B,">=11",B:B,"<=25")

Then in a summary sheet you could have a formula like this to count all the males between 11 and 25 from all of your sheets:

=SUM(first:last!X1)

where first and last are the names of the sheets which encompass all the other sheets (except for the summary).

Hope this helps.

Pete

Thanks TMS too, I'm back in the office tomorrow so will give these a try.

Your help is much appreciated

Cheers Pete, I'll have a go with this tomorrow.