Hi

A member provided the following code to count the contents of WorkSpace!CC based on the list at WorkSpace!G2 (G2-G11) and output results to DATA!D8-D17.

Sub Macro2()
'
Sheets("Data").Range("D8:D17").Formula = "=countif(WorkSpace!C:C,WorkSpace!G2)"
'
End Sub
In plain English this routine counts the number of Units in Workplace!C:C based on the list at WorkPlace!G2 and then outputs the results to Data!D8:D17.

I would like to count how many males/females/Not recorded are at each Unit. This data is in (WorkPlace!E:E). I have a list at H2 with Male/Female/Not recorded. Males will be stored at Data!D33:D42, Females at Data!E33:E42 & Not Recorded at Data!F33:F42

Hopes this make sense. Any assistance would be appreciated

Cheers