R

#### ricky

value and adds up the cells in a corresponding array for matches. Say

I have three columns A=Salesperson, B=Item Sold, C=Amount. I want to

sum up the total amount that salesman i sold of item j. I know how to

find the total for all things a particular salesman sold, and i can

find the total for all sales of a particular item, but how do i find a

total of all sales by a salesman of a particular item? I know there

are ways to implement this with filters and tons of other ways, but

with the way the data is available to me, some kind of modified sumif

strategy would be best