+ Reply to Thread
Results 1 to 5 of 5

Multiple sumif or if to find data based on many values.

  1. #1
    Registered User
    Join Date
    09-13-2011
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    Excel 2003
    Posts
    20

    Multiple sumif or if to find data based on many values.

    fileforhelp.xlsI am trying to create a spreadsheet that I can dump data into columns A:J, this data will identify duplicate part numbers and sum these for qty and sales and input into the appropriate columns for the respective dates. Example. If part number 1 is found 230 times in column C and this equls the part number in column M , then this amount will be sumed and that sum will be placed into U:4 for sales and V4 for units if they were in that month as indicated in column K. This way I can see how many we sold in January for part number 12345 (example) and see how many in Feb etc... I have tried vlookup, sumif and regular if but have not been able to get the results I need. Can anyone help???Attachment 151089
    Last edited by culverhr; 04-18-2012 at 03:35 PM.

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Multiple sumif or if to find data based on many values.

    Hello,

    Please Re-attach your file. It currently shows invalid link.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    09-13-2011
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Multiple sumif or if to find data based on many values.

    Sorry, I found that out and made the change. It should be curren.t

  4. #4
    Registered User
    Join Date
    09-13-2011
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Multiple sumif or if to find data based on many values.

    fileforhelpv3.xls

    This should work

  5. #5
    Registered User
    Join Date
    09-13-2011
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Multiple sumif or if to find data based on many values.

    Any ideas anyone?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1