Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I'm always coming up against this!
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find which column or row the Min() value is coming from | Excel Discussion (Misc queries) | |||
can anyone help with times not coming across correctly in pivot t. | Excel Worksheet Functions | |||
can anyone help with times not coming across correctly in pivot t. | Excel Worksheet Functions | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Coming up with #N/A | Excel Worksheet Functions |