Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy from a Cell to a text box. | Excel Worksheet Functions | |||
count cells that begin with specific text | Excel Worksheet Functions | |||
vertical text across multiple cells | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions |