Count single Text in cells with multiple text entries
Current Array Formula:
=SUM((RawData!$CT$2:$CT$1757=$B3)*(RawData!$A$2:$A $1757=$C3)*((RawData!$DE$2:$DE$1757="A")*(RawData! $DE$2:$DE$1757="A
B")*(RawData!$DE$2:$DE$1757="A B T")*(RawData!$DE$2:$DE$1757="A T")))
Where B3 is the organization, C3 is the personnel code, I want to count by
organization then personnel code type, those that have "A" in column DE. DE
lists the 4 text codes, and I need to count every instance that "A" appears.
It is entered as an array. Currently returns 0, when there is text data to
count. Thoughts?
Thanks.
|