I'm trying to setup an excel spreadsheet to find the total dollar amount of comps given for several different vendors all out off one mass mixed up spreadsheet.
I want to search for a specific name and then get a sum of the dollar amount in the cell to the right of it, over the entire list.
Any ideas?

Quote:

---

Originally Posted by Meyerp006

I'm trying to setup an excel spreadsheet to find the total dollar amount of comps given for several different vendors all out off one mass mixed up spreadsheet.
I want to search for a specific name and then get a sum of the dollar amount in the cell to the right of it, over the entire list.
Any ideas?

---

What I would do is highlight the entire document, sort ascending by Vendor Name.
Once this task is completed, highlight the entire document again. Click on Data/Subtotals
Subtotal at each change in Vendor Name, In the function box, choose SUM

And then in the Add Subtotal To box, choose your comp field. This should give you an overall total for each vendor. You should be able to find your specific vendor a lot more quick and easier that way.

Quote:

---

Originally Posted by Meyerp006

I'm trying to setup an excel spreadsheet to find the total dollar amount of comps given for several different vendors all out off one mass mixed up spreadsheet.
I want to search for a specific name and then get a sum of the dollar amount in the cell to the right of it, over the entire list.
Any ideas?

---

Try the help menue for Vlooklup, it does what you are asking for - it's a funsion within excel although you may have to get excel 2003 onwards for this