phillygirl777
Member
Hello,
The attached spreadsheet contains 2 tabs.
Sheet1 is the original example where we got the summary of sales by region by distribution channel.
Part 2 (red) is the same example, but with an additional criterion. I had to separate products by Type (Meat and Produce) and get the answer for one group only (let's say, meat). I tried adding another match, but got the #VALUE error.
Any ideas?
THANK YOU!!!!!!!!
The attached spreadsheet contains 2 tabs.
Sheet1 is the original example where we got the summary of sales by region by distribution channel.
Part 2 (red) is the same example, but with an additional criterion. I had to separate products by Type (Meat and Produce) and get the answer for one group only (let's say, meat). I tried adding another match, but got the #VALUE error.
Any ideas?
THANK YOU!!!!!!!!
Last edited by a moderator:
