LOOKUP ???? Not Sure...

[Nuyorican]

Good Evening,

I have 6 worksheets, for arguments sake...sheets A thru F. Each sheet has 4 columns, NAME, SSN, GROSS EARNINGS, and PAYOUT. 99.9% of the names appear in every sheet. I would like to show (on a separate sheet), the TOTAL gross earnings and payout for each person. Help, please. Thank you.

Benny Torres

 

[Padawan]

Benny

I think what you are asking for is simply to total accross the four sheets?

If so, the easiest way is to :
1. begin your formula on your compilation sheet, [I'll presume Sheet F] in the cell you
want with the =,
2. Click on sheet A, then on the cell you want to sum,
3. type a +
4. Click on Sheet B and click on the cell you want to add
5. Repeat 2 - 4 for sheets C, D & E
6. Then hit your enter key.

This will add the values accross the different spreadsheets.

HTH.

John

 

[Haseeb Avarakkan]

Hello,

Enter your 6 sheet names in the new sheet, say A2:A7, and enter the personnel names in the B2 to dwon, then try this formula.

=SUMPRODUCT(SUMIF(INDIRECT("'"&$A$2:$A$7&"'!A:A"),B2,INDIRECT("'"&$A$2:$A$7&"'!C:C")))

Where A:A contains 'Names' & C:C contains 'GROSS EARNINGS'

Change the ranges accordingly.

Also Pivot Tabele is better.

 

[snoopyhr]

Or.... you can utilize Pivot table to do it for you by selecting multiple consolidation ranges function of it. It is lot faster , more accurate (you point and select the range you want) and added bonus is you can have sum of gross, sum of pay out, count of names (check for completeness)

Just a suggestion , give it a shot,

 

[Nuyorican]

I had to leave prematurely yesterday. I just wanted to thank everyone. The suggestion of the "Pivot Table", was the answer. Thanks again.

Benny