Results 1 to 6 of 6

Thread: Formula with IFs

  1. #1

    Formula with IFs



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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).

    Please help!!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Exel Formula.JPG 
Views:	9 
Size:	57.2 KB 
ID:	3575  

  2. #2

    Formula with IFs with .xls File

    Here is my sample .xls file.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Exel Formula.JPG 
Views:	0 
Size:	57.2 KB 
ID:	3579  
    Attached Files Attached Files

  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    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.

    plz see the attachment. is this help you ?
    Attached Files Attached Files

  4. #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. #5
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    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. #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
  •