How to use vlookup then sum the results of multiple sheets

[Billznik]

I have workbook with a sheet for each month of the year with a list of people who have generated me a certain amount of money each month. The problem is, the people aren't always in the same order on each sheet, so I think I need to use vlookup for each name on a master list and sum the total from all of the values that correspond to them on the third column to to the right of their name. Can anyone help? Let me know if I need to explain more clearly.

-Bill

[Carim]

Hi,

First things first ...

Have you ever tried/used the vlookup() function ...?
if not press F1 to go to help search vlookup() to understand the concept ...


Carim

[Billznik]

Sorry, I'm a newb, but yes I do understand the concept and use it for other things. I just need to look up a specific name in all of my sheets, once or if it finds the name I want it to add the value in the third column to the right that it finds for that name in EVERY sheet. Is this possible? Thanks!

[Carim]

Hi,

If you understand the vlookup() function, you can add them up to achieve your objective ...

i.e.

vlookup(1)+vlookup(2)+vlookup(3)+etc ...

HTH
Carim