| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to count text with two conditions.
Can someone help me figure out how to get a count on specific text items
that meet two conditions? I have two columns. Each column has approximately five different groups of text in them. I need a count on the number of items from column two that match up with specific text from column one. For example, column one has LA, Foreign, and States. Column two has yes, no, and maybe. I need the count on how many yesses there are that match up with States. I'm using Excel Office 2003. I know this is probably confusing...thanks so much for any help you can give me! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count text with two conditions.
Hi,
I'm not sure I understand but try this =SUMPRODUCT((A1:A100="States")*(B1:B100="Yes")) Mike "Folletti" wrote: Can someone help me figure out how to get a count on specific text items that meet two conditions? I have two columns. Each column has approximately five different groups of text in them. I need a count on the number of items from column two that match up with specific text from column one. For example, column one has LA, Foreign, and States. Column two has yes, no, and maybe. I need the count on how many yesses there are that match up with States. I'm using Excel Office 2003. I know this is probably confusing...thanks so much for any help you can give me! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count text with two conditions.
Thank you so much!! I've been trying to figure this out for weeks, and
finally foudn this site. You're a lifesaver! "Mike H" wrote: Hi, I'm not sure I understand but try this =SUMPRODUCT((A1:A100="States")*(B1:B100="Yes")) Mike "Folletti" wrote: Can someone help me figure out how to get a count on specific text items that meet two conditions? I have two columns. Each column has approximately five different groups of text in them. I need a count on the number of items from column two that match up with specific text from column one. For example, column one has LA, Foreign, and States. Column two has yes, no, and maybe. I need the count on how many yesses there are that match up with States. I'm using Excel Office 2003. I know this is probably confusing...thanks so much for any help you can give me! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count text with two conditions.
Glad I could help
"Folletti" wrote: Thank you so much!! I've been trying to figure this out for weeks, and finally foudn this site. You're a lifesaver! "Mike H" wrote: Hi, I'm not sure I understand but try this =SUMPRODUCT((A1:A100="States")*(B1:B100="Yes")) Mike "Folletti" wrote: Can someone help me figure out how to get a count on specific text items that meet two conditions? I have two columns. Each column has approximately five different groups of text in them. I need a count on the number of items from column two that match up with specific text from column one. For example, column one has LA, Foreign, and States. Column two has yes, no, and maybe. I need the count on how many yesses there are that match up with States. I'm using Excel Office 2003. I know this is probably confusing...thanks so much for any help you can give me! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a formula to count depending on conditions | Excel Discussion (Misc queries) | |||
| Count text based on multiple (2) conditions | Excel Worksheet Functions | |||
| Formula to count TWO conditions are met | Excel Discussion (Misc queries) | |||
| COUNT formula need two conditions | Excel Worksheet Functions | |||
| Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
Linear Mode
