CHALLENGE - Extract data from a table with multiple conditions....

**horkstar** · 10-16-2014, 10:44 AM

Hello,

I am looking to create a new Service report at work. Our system extracts a list of customers with a list of products and then gives the order/dispatch quantity over the next week.

I want to create a summary sheet which will look all the entries for Customer A on Monday and total all the cases of products dispatched on that day. Then obviously copy across for the remaining days of the week.

I may need to add several other conditions but at the moment in column A is the Customer, Column B the product and then across the top row we have the days of the week in Sunday-Saturday.

Formulas such as Sumproduct, Index-Match, SUMIF has been tried but keep pulling NA or VALUE entries and im going abit crazy!

Anyone help at all?

Thanks in advance!

**alansidman** · 10-16-2014, 10:45 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**horkstar** · 10-16-2014, 11:35 AM

Hello,

I have added the sample table to the attached.

Tried to add my sample formulas and give a breakdown of what is required. i.e. the yellow cell at the top denotes the correct value which should be pulled through from the bottom table.

I always want the table to pull through the TOTAL figure so this needs to be looked up as a third parameter.

Thanks