excel

[Guest]

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

:

 

[Guest]

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=ig&hl=en&q=excel+sumproduct

Post back with any questions.

Dave

 

[Guest]

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