Forum Discussion
Count sales of different products to same customer Excel
Hello, I am trying to get at some cross buying behavior from a large data set that I have. Attached is a simple bit of sample data and then my desired output. There is a ton of data in my actual w...
Chas,
not the best solution.
Define named ranges:
Brand_A ='Sample Pivot Table'!$C$3:$C$5
Brand_B ='Sample Pivot Table'!$D$3:$D$5
Brand_C ='Sample Pivot Table'!$E$3:$E$5
Brand_D ='Sample Pivot Table'!$F$3:$F$5
And then this formula in C3:
=SUMPRODUCT(INDIRECT(SUBSTITUTE($B3," ","_"))*INDIRECT(SUBSTITUTE(C$2," ","_")))
Great, thank you!