| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| Counting based upon 2 conditions that are text based | Excel Discussion (Misc queries) | |||
| Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Linear Mode
