stock sample.xlsxHello to you all and thank you for taking the time to look through my problem and hopefully helping me to find the solution
Bssically the attached sheet is a very small table set up in the same way as the worksheet currently being manually filled on a daily basis.
Essentially I would like to be able to sum the total number of pallets by product type brought in by each supplier, unfortunately there are multiple deliveries by the same suppliers and the input list is chronological. Appreciate a pivot table would add everything up but the table forms the basis of the crude stock control in place so all potential product types need to be onshow even if no delivery of that product is made.
I have previously used the formula =SUMPRODUCT(($C$4:$C$21=$H4)*($D$4:$D$21=I$3),$E$4:$E$21) however that table had information in columns and not rows and obviously does not work at all in this case.
What would be the solution which would auto populate cell e29 for example with the total number of pallets of product1 delivered by supplier jeff.
I may be causing issues by using Product1, product2, product3 for each supplier as a quick method of showing the table. each supplier has a different name for their products.
All or any help is gratefully recieved.
Kind regards
Damion
Bookmarks