I'm asking too much
I never said that. I suggested a possible alternative.


What's your expected results ??

A total of Unquie items or list all 30 answer in one cell with a count ??

e.g for D9 would you have something like


Quote:
="Males Tot "&COUNTIF(K:K,"male")&" / "&"Female Tot "&COUNTIF(K:K,"Female")
Also you never answered this question

VBA Noob