Hi, I'm trying to write a sumifs formula but I'm having no joy. Hopefully someone out there can help.
I need to sum all the quantities that match the product and the method from sheet 1 into sheet 2
Sheet 1
Product Qty Method
ABC 7 Phone
DEF 4 Website
GHI 2 Phone
ABC 3 Website
Sheet 2
Product Phone Website
ABC 7 3
DEF 4
GHI 2
I need to sum all the quantities that match the product and the method from sheet 1 into sheet 2
Sheet 1
Product Qty Method
ABC 7 Phone
DEF 4 Website
GHI 2 Phone
ABC 3 Website
Sheet 2
Product Phone Website
ABC 7 3
DEF 4
GHI 2