Try SUMPRODUCT:-
=Sumproduct((RANGE_1="Criteria1")*(Range_2="Criter ia2"))
Range1 and Range2 need to have the same number of rows in
Regards
Andy
"Michelle Tucker" wrote in
message ...
I always seem to have this problem, and any solutions I have I don't truly
understand!
I have a list of products sold in one column, and in the next, the name of
the salesperson who sold it.
What I want to do is count up the amount of particular products sold by each
person.
I understand countif and sumif, but it seems to be done with a combintation
of INDEX and MATCH, which I don't get.
What is the easiest way to do this as it is something I always seem to need
to do, but then chicken out!
--
Michelle Tucker
|