1.png
I have simplified a bigger problem I have simplified the problem here. Your help would be greatly appreciated. What is most important to me is a simple shortest solution.
I have to arrays:
Array 1 - A1:A14 - These are the company names
Array 2 - B1:B14 - These are the products that the company create.
I have been trying to create a formula that says if A1:A14 is "Heinz" then look in the corresponding array if it says specified lables then count it. It this case I want it to count "Mummys Sauce", "Daddies Sauce", "Couzin Sauce"
So in this simplified example the the answer would Count and equal the answer = 10
Ialready have two solutions but they are not wuite correct
***DOES NOT WORK
=SUMPRODUCT(--(A1:A14 ="Heinz"), --(B1:B14 = {"Mummys Sauce","Daddies Sauce","Couzin Sauce"}) )
If I could get this style of formula working it but be EXACTLY what I need. The reason is because I reference external sheets on real solution the linkage because absolutely unmanageable. Im ideally looking for this to work.
***WORKS:
=SUMPRODUCT(--(A1:A14 ="Heinz"), --((B1:B14 ="Mummys Sauce") + (B1:B14 ="Daddies Sauce") + (B1:B14 ="Couzin Sauce") >0) )
This solution does work but Ive tried using it. But when I add all the linkage it becomes massive. Each cell 10 pages long. Hence me wondering if the first formula can be fixed
Bookmarks