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
Bookmarks