Sum formula

[jpforg]

I would like to know if there is a way to SUM information up in one cell if text matches in another cell. I know there is the SUMIF function however this requires you to put in the text you want to match but for my application that would mean creating like 3000 different formulas. So basically want I want is the

Store	Employee	Sales
Best Buy	Jason	10
Best Buy	John	5
Best Buy	Jim	8
Walmart	Tom	5
Walmart	Tim	5
Walmart	Tina	7
Sears	Nick	6
Best Buy	Jason	11
Best Buy	John	3

What I would want to show is that Best buy, Jason, 21 in one row. In the actual data Im working with the names in column 2 will match and always have the same information in column 1, IE Jason only works at best buy and no other store so I only need to add if up if Text in column 2 matches but want my information to come out with all the columns. I can do the adding with a pivot table however if I copy and paste it out I will loose the information in the first column. Does this make sense?

[Pete_UK]

No, it doesn't make much sense to me.

Create a unique list of the stores and employees in two other columns (e.g. columns D and E) and then in F2 you could have this formula:

=SUMIFS(C:C,A:A,D2,B:B,E2)

then copy down your subsidiary table.

Hope this helps.

Pete

[jpforg]

Thanks for the reply. Im not sure how this will work for my situation but it has given me an idea.

Thanks,
Jason