Я только что попытался запустить заведомо длинную формулу, и Excel вернулся, чтобы сказать мне, что она слишком длинная. В настоящее время я использую СУММ для ряда (вероятно, 30-40) формул СУММПРОИЗВ.
Немного предыстории: я пытаюсь сопоставить происхождение и место назначения продукта, поэтому я создал новый лист (лист 2), в котором все страны мира перечислены в столбце 1 и в строке 1. Формула СУММПРОИЗВ, которую я написал входит в Лист 1, где есть ряд столбцов, содержащих происхождение и назначение различных продуктов. Строки основаны на каждой организации, поэтому у одной организации может быть 13 продуктов с разными странами происхождения и несколькими пунктами назначения для каждого продукта.
Формула СУММПРОИЗВ, которую я использую, выглядит так:
=SUMPRODUCT((BA2:BA501="NO")*(P2:P501="Guatemala")*(R2:R501="Guatemala")*(S2:S501)
P = страна происхождения
R = страна назначения
S = объем для суммирования
BA = в некоторых случаях у меня есть фактическое распространение продукта, поэтому объем «назначения» не должен быть включен. Таким образом, он должен использовать пункт назначения только в том случае, если BA = 0.
Мне пришлось идентифицировать различные столбцы вручную, что привело к поистине ужасающей длине SUMPRODUCTS, которую я затем использовал SUM(Sumproduct 1, 2, 3...), чтобы получить общее количество продуктов, соответствующих СТРАНЕ происхождения/назначения в матрица на листе 2.
Итак, проделав всю эту работу, я немного расстроен тем, что Excel говорит, что это слишком долго! Кто-нибудь знает, есть ли способ обойти это, или есть какое-то решение, которое я пропускаю?
Спасибо!
p.s. Я сомневаюсь, что кому-то интересно это читать, но вот полная формула, которую Excel отклонил:
=SUM(SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="NO")*('IN BETWEEN, ALL'!$P$2:$P$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$R$2:$R$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$S$2:$S$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="NO")*('IN BETWEEN, ALL'!$P$2:$P$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$T$2:$T$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$U$2:$U$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="NO")*('IN BETWEEN, ALL'!$P$2:$P$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$V$2:$V$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$W$2:$W$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="NO")*('IN BETWEEN, ALL'!$P$2:$P$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$X$2:$X$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$Y$2:$Y$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="NO")*('IN BETWEEN, ALL'!$P$2:$P$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$Z$2:$Z$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$AA$2:$AA$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="NO")*('IN BETWEEN, ALL'!$P$2:$P$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$AB$2:$AB$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$AC$2:$AC$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="YES")*('IN BETWEEN, ALL'!$P$2:$P$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$AX$2:$AX$501='THE FLOW OF COOKSTOVES -WI ORG'!CE$2)*('IN BETWEEN, ALL'!$AZ$2:$AZ$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="NO")*('IN BETWEEN, ALL'!$AE$2:$AE$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$AG$2:$AG$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$AH$2:$AH$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="NO")*('IN BETWEEN, ALL'!$AE$2:$AE$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$AI$2:$AI$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$AJ$2:$AJ$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="NO")*('IN BETWEEN, ALL'!$AE$2:$AE$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$AK$2:$AK$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$AL$2:$AL$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="NO")*('IN BETWEEN, ALL'!$AE$2:$AE$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$AM$2:$AM$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$AN$2:$AN$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BA$2:$BA$501="NO")*('IN BETWEEN, ALL'!$AE$2:$AE$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$AO$2:$AO$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$AP$2:$AP$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BV$2:$BV$501="NO")*('IN BETWEEN, ALL'!$BD$2:$BD$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$BF$2:$BF$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$BG$2:$BG$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BV$2:$BV$501="NO")*('IN BETWEEN, ALL'!$BD$2:$BD$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$BH$2:$BH$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$BI$2:$BI$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BV$2:$BV$501="NO")*('IN BETWEEN, ALL'!$BD$2:$BD$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$BJ$2:$BJ$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$BK$2:$BK$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BV$2:$BV$501="NO")*('IN BETWEEN, ALL'!$BD$2:$BD$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$BL$2:$BL$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$BM$2:$BM$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BV$2:$BV$501="NO")*('IN BETWEEN, ALL'!$BD$2:$BD$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$BN$2:$BN$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$BO$2:$BO$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BV$2:$BV$501="NO")*('IN BETWEEN, ALL'!$BD$2:$BD$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$BP$2:$BP$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$BQ$2:$BQ$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$BV$2:$BV$501="YES")*('IN BETWEEN, ALL'!$BD$2:$BD$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$BS$2:$BS$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$BU$2:$BU$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$CQ$2:$CQ$501="NO")*('IN BETWEEN, ALL'!$BY$2:$BY$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$CA$2:$CA501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$CB$2:$CB$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$CQ$2:$CQ$501="NO")*('IN BETWEEN, ALL'!$BY$2:$BY$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$CC$2:$CC501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$CD$2:$CD$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$CQ$2:$CQ$501="NO")*('IN BETWEEN, ALL'!$BY$2:$BY$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$CE$2:$CE501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$CF$2:$CF$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$CQ$2:$CQ$501="NO")*('IN BETWEEN, ALL'!$BY$2:$BY$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$CG$2:$CG501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$CH$2:$CH$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$CQ$2:$CQ$501="NO")*('IN BETWEEN, ALL'!$BY$2:$BY$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$CI$2:$CI501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$CJ$2:$CJ$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$CQ$2:$CQ$501="NO")*('IN BETWEEN, ALL'!$BY$2:$BY$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$CK$2:$CK501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$CL$2:$CL$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$CQ$2:$CQ$501="YES")*('IN BETWEEN, ALL'!$BY$2:$BY$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$CN$2:$CN501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$CP$2:$CP$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$DL$2:$DL$501="NO")*('IN BETWEEN, ALL'!$CT$2:$CT$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$CV$2:$CV$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$CW$2:$CW$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$DL$2:$DL$501="NO")*('IN BETWEEN, ALL'!$CT$2:$CT$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$CX$2:$CX$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$CY$2:$CY$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$DL$2:$DL$501="NO")*('IN BETWEEN, ALL'!$CT$2:$CT$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$CZ$2:$CZ$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$DA$2:$DA$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$DL$2:$DL$501="NO")*('IN BETWEEN, ALL'!$CT$2:$CT$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$DB$2:$DB$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$DC$2:$DC$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$DL$2:$DL$501="NO")*('IN BETWEEN, ALL'!$CT$2:$CT$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$DD$2:$DD$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$DE$2:$DE$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$DL$2:$DL$501="NO")*('IN BETWEEN, ALL'!$CT$2:$CT$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$DF$2:$DF$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$DG$2:$DG$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$DL$2:$DL$501="YES")*('IN BETWEEN, ALL'!$CT$2:$CT$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$DI$2:$DI$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$DK$2:$DK$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$EG$2:$EG$501="NO")*('IN BETWEEN, ALL'!$DO2:$DO$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$DQ$2:$DQ$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$DR$2:$DR$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$EG$2:$EG$501="NO")*('IN BETWEEN, ALL'!$DO2:$DO$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$DS$2:$DS$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$DT$2:$DT$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$EG$2:$EG$501="NO")*('IN BETWEEN, ALL'!$DO2:$DO$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$DU$2:$DU$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$DV$2:$DV$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$EG$2:$EG$501="NO")*('IN BETWEEN, ALL'!$DO2:$DO$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$DW$2:$DW$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$DX$2:$DX$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$EG$2:$EG$501="NO")*('IN BETWEEN, ALL'!$DO2:$DO$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$DY$2:$DY$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$DZ$2:$DZ$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$EG$2:$EG$501="NO")*('IN BETWEEN, ALL'!$DO2:$DO$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$EA$2:$EA$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$EB$2:$EB$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$EG$2:$EG$501="YES")*('IN BETWEEN, ALL'!$DO2:$DO$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$ED$2:$ED$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$EF$2:$EF$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$FB$2:$FB$501="NO")*('IN BETWEEN, ALL'!$EJ2:$EJ$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$EL$2:$EL$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$EM$2:$EM$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$FB$2:$FB$501="NO")*('IN BETWEEN, ALL'!$EJ2:$EJ$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$EN$2:$EN$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$EO$2:$EO$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$FB$2:$FB$501="NO")*('IN BETWEEN, ALL'!$EJ2:$EJ$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$EP$2:$EP$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$EQ$2:$EQ$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$FB$2:$FB$501="NO")*('IN BETWEEN, ALL'!$EJ2:$EJ$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$ER$2:$ER$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$ES$2:$ES$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$FB$2:$FB$501="NO")*('IN BETWEEN, ALL'!$EJ2:$EJ$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$ET$2:$ET$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$EU$2:$EU$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$FB$2:$FB$501="NO")*('IN BETWEEN, ALL'!$EJ2:$EJ$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$EV$2:$EV$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$EW$2:$EW$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$FB$2:$FB$501="YES")*('IN BETWEEN, ALL'!$EJ2:$EJ$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$EY$2:$EY$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$FA$2:$FA$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$FE2:$FE$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$FG$2:$FG$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$FI$2:$FI$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$FL2:$FL$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$FN$2:$FN$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$FP$2:$FP$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$FS2:$FS$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$FU$2:$FU$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$FW$2:$FW$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$FZ2:$FZ$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$GB$2:$GB$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$GD$2:$GD$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$GG2:$GG$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$GI$2:$GI$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$GK$2:$GK$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$GN2:$GN$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$GP$2:$GP$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$GR$2:$GR$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$GU2:$GU$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$GW$2:$GW$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$GY$2:$GY$501)),SUMPRODUCT(('IN BETWEEN, ALL'!$IL2:$IL$501='THE FLOW OF COOKSTOVES -WI ORG'!$B124)*('IN BETWEEN, ALL'!$IO$2:$IO$501='THE FLOW OF COOKSTOVES -WI ORG'!EC$2)*('IN BETWEEN, ALL'!$IR$2:$IR$501)))
