Formula for male and female staff on rota

Hi

I have a section in my rota that calculates how many staff are working on each shift but I would also like to see how many male and female staff are on. My rota is for the care home I work for and at least one male member of staff must be on shift at each time so this would be very useful.

Could someone give me some guidance?

Also, I have created this rota on Excel 2010 but our office pc is 2007 and when on the office pc the drop down boxes etc are not working. Could someone tell me how I make this compatible with 2007?

Many thanks in advance

Tiger

Hi bigtiger1,
Can you insert some data, all is showing zero. And lets us know, the expected result is located at?
Please manually do some sample result. So we can just write a formula inside the worksheet. Thanks :D

Staff Schedule (EDIT).xlsx

Please check, is this okie for you:D

I'm using 2007 as well.
Where is the drop down box?

I can see the list to choose staff name and the shift are follow behind. There is no drop down list below each weekday.
How you create your drop down?

http://www.officearticles.com/excel/...soft_excel.htm

You can follow this one, and create for only staff name and shift time.

Okay,obviously is not in my side. If you follow the steps that i send you. I confirm it will worked. As i already did in my site.
You can send me again, if you can double check the list:D

Staff Schedule (EDIT2).xlsx

I create with excel 2007.
I name the range as TimeShift
And create the list at C6
If you with to apply to other cell. Just simply copy and paste to other cell.
I think it will worked in your other pc with excel 2007:

Hi bigtiger1,
any issue regards your problem? If is solved, please mark as SOLVED.

That's great