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!