Try this:
=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")))

Does that work?

--
Brevity is the soul of wit.


"WSC" wrote:

Dave - thanks - just not sure where to use the double negation in this string
to get it to work. Have tried multiple locations with no success

WSC

"Dave F" wrote:

Use the double negation operator to convert the array formula into something
that can be counted:
http://www.dailydoseofexcel.com/arch...rray-formulas/

Dave
--
Brevity is the soul of wit.


"WSC" wrote:

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.