Reference to a specific 2 cells

[lenabiel]

Hi,

I have sales for Target product A, B, C, D and then sales for Amazon product A, B, Walmart product A, D. How do I calculate what were the percentage of sales for each customer/product referring to Target/ specific product?

Thank you in advance.

Lena

 

[Peter_SSs]

Welcome to the MrExcel board!

I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be.