1. Formula with IFs

How can I transfer information from sheet 1 to sheet 2. For example: Sheet 1 shows Column B as "Employee #" and Column C as "Name" and Column D as "Sales Amount". I would like to input the unique employee # in Sheet 2 A2 and have the information auto fill B2 (Name) and B3 (sum Total Sales).

2. Formula with IFs with .xls File

Here is my sample .xls file.

3. Hi,
As per your data Toal Sales Amt. of Tom is \$144.00, but as per Sheet 1 sales amount of Tom (Employ ID 0003) i.e, \$105,\$39 & \$55. if we add the amount it should be \$199. please check your data.

Try sumif function.

4. Thank you for the info. Yes, perhaps I did not add correctly. I suppose my explanation was not detailed enough......I would like to input only the Employee # in Column A and auto fill Column B with the corresponding name and auto fill Column C with sum of Total Sales for that person. I suppose I need to do a VLOOKUP for Column B, but how do I sum the sales for that particular person. Would that be a VLOOKUP as well?

5. As Sambit mentioned, you would need SUMIF in column C...

Try:

Code:
`=SUMIF(Sheet1!B:B,A2,Sheet1!D:D)`
copied down.

the Vlookup in B2 would be:

Code:
`=VLOOKUP(A2,Sheet1!B:D,2,0)`
copied down

6. YES!!!! That's it!!! Works just as I needed it!!! Thank you for all your help and guidance!!!!

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•