| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i count a combination of name white a product.
dear all,
i am building an template for a support helpdesk. But i can't find the right formule to count the amouth of company1 whit a problem1 for example. sow that i can see howmany times company 1 has problem1 or how many time they hade a problem2. please let my now !! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i count a combination of name white a product.
=SUMPRODUCT(--(A2:A200="Company 1"),--(B2:B200="Problem1"))
etc. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rudi" wrote in message ... dear all, i am building an template for a support helpdesk. But i can't find the right formule to count the amouth of company1 whit a problem1 for example. sow that i can see howmany times company 1 has problem1 or how many time they hade a problem2. please let my now !! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #REF! trying to white out | Excel Worksheet Functions | |||
| top ten customers by transaction count by product | Excel Worksheet Functions | |||
| Is there one or combination of Excel function to count unique entr | Excel Discussion (Misc queries) | |||
| EXCEL workbook is off-white, goes white in edit mode | Excel Discussion (Misc queries) | |||
| How to set a formula to count the product appear how manytime | Excel Worksheet Functions | |||
Linear Mode
