counting a text value based on another text value.

R

Rob K.

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
 
R

Rasoul Khoshravan

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
Click to expand...
Have a look at countif() function in XL help.
count number of a col when a criteria is met in another column.
 
T

T. Valko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the columns from one sheet and paste it in another sheet 0
Help needed 0
counting unique values of text 4
Filter based on list 1
Counting unique values in column 3
Totals f(x) text values in multiple columns and cells 10
Counting number of items excluding duplicates. 1
Really counting DATES 15

Top