Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel
Dave , Thanks very much. I'm a first time user here, so forgive my ignorance.
The answer you gave fixed my problem. Only that has lead me to attempt further adjusting to someone else's excel sheet. If you don't mind, here are some more questions. the sheet tracks car sales,porsche-audi/ new and used, I would like to count the sales per person(you answered that one) and count by new audi, new porsche, used audi and used porsche. In my columns are listed N or U, Audi or Porsche. Thanks "Dave F" wrote: |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel
I'm not sure what problem of yours I solved as the thread seems to have
disappeared. However it sounds like the SUMPRODUCT function may help you here. Without more detail, though I have no idea. Take a look at the links here and see if it helps: http://www.google.com/search?source=...cel+sumproduct Post back with any questions. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "M.GONZALEZ" wrote: Dave , Thanks very much. I'm a first time user here, so forgive my ignorance. The answer you gave fixed my problem. Only that has lead me to attempt further adjusting to someone else's excel sheet. If you don't mind, here are some more questions. the sheet tracks car sales,porsche-audi/ new and used, I would like to count the sales per person(you answered that one) and count by new audi, new porsche, used audi and used porsche. In my columns are listed N or U, Audi or Porsche. Thanks "Dave F" wrote: |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel
OK I found your old post.
Basically: COUNTIF(...) works with one criteria. SUMPRODUCT(....) will allow you to count records that match multiple criteria. =SUMPRODUCT(--(A1:A10="porsche"),--(B1:B10="new"),--(C1:C10="Dave")) will count all records where the criteria "porsche" is in A1:A10, the criteria "new" is in B1:B10, and the criteria "Dave" is in C1:C10. Adjust the formula to suit your ranges/criteria. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Dave F" wrote: I'm not sure what problem of yours I solved as the thread seems to have disappeared. However it sounds like the SUMPRODUCT function may help you here. Without more detail, though I have no idea. Take a look at the links here and see if it helps: http://www.google.com/search?source=...cel+sumproduct Post back with any questions. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "M.GONZALEZ" wrote: Dave , Thanks very much. I'm a first time user here, so forgive my ignorance. The answer you gave fixed my problem. Only that has lead me to attempt further adjusting to someone else's excel sheet. If you don't mind, here are some more questions. the sheet tracks car sales,porsche-audi/ new and used, I would like to count the sales per person(you answered that one) and count by new audi, new porsche, used audi and used porsche. In my columns are listed N or U, Audi or Porsche. Thanks "Dave F" wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|