Forum Discussion
Solved
The formula for adding numbers with condition doesn`t work
=СУММ(СУММЕСЛИМН(ONE!$P$9:$P$3344;
ONE!$D$9:$D$3344;"*1*";
ONE!$H$9:$H$3344;"*2*";
ONE!$AL$9:$AL$3344;{">50";"<100"})) I can’t correctly write a working formula in an excel that simultaneous...
=СУММПРОИЗВ(
(ONE!$P$9:$P$3344)*
(ЕЧИСЛО(ПОИСК(1;ONE!$D$9:$D$3344)))*(ЕЧИСЛО(ПОИСК(2;ONE!$H$9:$H$3344)))*
(ONE!$AL$9:$AL$3344>50)*
(ONE!$AL$9:$AL$3344<100)
)
This works in my sheet if i correctly understand what you want to do.
=СУММПРОИЗВ(
(ONE!$P$9:$P$3344)*
(ЕЧИСЛО(ПОИСК(1;ONE!$D$9:$D$3344)))*(ЕЧИСЛО(ПОИСК(2;ONE!$H$9:$H$3344)))*
(ONE!$AL$9:$AL$3344>50)*
(ONE!$AL$9:$AL$3344<100)
)
This works in my sheet if i correctly understand what you want to do.