Cant seem to count

[AndyGav86]

Hi, So I am trying to count how many male and female officers are on per shift, I have made a sheet so that the male officers are under one column and the female officers are under another then i put column next to the officers with an M or F. This is a separate sheet to the main sheet i want the number to appear

All i want to do is when i put the names in column B below i want "T1" & "V1" to display the number of how many male and females

I hope that this makes sense, I did try a countifs but didn't work

Many Thanks in advance

Andy

 

[Fluff]

I did try a countifs but didn't work

What did you try & in what way didn't it work?

 

[steve the fish]

You could try this changing sheet names/ranges to suit:

=SUM(--(IFERROR(VLOOKUP($B$4:$B$20,Sheet2!$A$2:$B$20,2,0),"")=S1))

 

[AndyGav86]

What did you try & in what way didn't it work?

 

[Fluff]

Thanks for that. How about

=SUM(COUNTIFS('Hidden Data'!A:A,B4:B26,'Hidden Data'!B:B,"M"))

 

[AndyGav86]

You could try this changing sheet names/ranges to suit:

=SUM(--(IFERROR(VLOOKUP($B$4:$B$20,Sheet2!$A$2:$B$20,2,0),"")=S1

Thanks for that. How about

=SUM(COUNTIFS('Hidden Data'!A:A,B4:B26,'Hidden Data'!B:B,"M"))

THANK YOU Amazing as usual, All fixed

 

[Fluff]

Glad we could help & thanks for the feedback.