Using a countif function for text string data.

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

sorry......

Well I'm linking the answers into another sheet that will state;

Number of males =
Number of females =

So I suppose a single count? I'll add another row for counting females?

Tell me Noob, how would this apply to the more complicated answers, such as the drop down list in cell L20???

What's your expected results ??

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

Still didn't answer it.

Maybe post a sample with expected results in those cells

VBA Noob

Try this in D10 for starters

=SUMPRODUCT(--(TEXT(A22:A200,"MMYY")=TEXT(D5,"MMYY"))*(K22:K200="Male")*(G22:G200="Armagh / Dungannon"))

If you change D3 to a drop down then use

=SUMPRODUCT(--(TEXT(A22:A200,"MMYY")=TEXT(D5,"MMYY"))*(K22:K200="Male")*(G22:G200=D3))

For unique items try e.g D12 would be

=SUMPRODUCT((J22:J200<>"")/COUNTIF(J22:J200,J22:J200&""))

Change ranges as required

VBA Noob