counting a text value based on another text value.
 

I am trying to count how many people in a given work group listed in one
column with a status listed in another column. Both values are text
--
Rob Karnes

counting a text value based on another text value.
 

On Feb 19, 7:06*am, Rob K. wrote:
I am trying to count how many people in a given work group listed in one
column with a status listed in another column. *Both values are text
--
Rob Karnes
Have a look at countif() function in XL help.
count number of a col when a criteria is met in another column.

counting a text value based on another text value.
 

Try something like this:

=SUMPRODUCT(--(A1:A10="workgroup"),--(B1:B10="status"))

Better to use cells to hold the criteria:

D1 = some workgroup
R1 = some status

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1))

If that's not what you had in mind you'll need to provide more detail.

--
Biff
Microsoft Excel MVP


"Rob K." wrote in message
...
I am trying to count how many people in a given work group listed in one
column with a status listed in another column. Both values are text
--
Rob Karnes