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 simultaneously searches for the number more than 50 and less than 100. I don’t understand what the problem is... plz help me -_-
=СУММПРОИЗВ(
(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.
1 Reply
=СУММПРОИЗВ(
(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.