Thursday, 04 June, 2026г.
russian english deutsch french spanish portuguese czech greek georgian chinese japanese korean indonesian turkish thai uzbek

пример: покупка автомобиля в Запорожье

 

Sum multiple values from data validation list/ Excel 2013

Sum multiple values from data validation list/ Excel 2013У вашего броузера проблема в совместимости с HTML5
=SUMPRODUCT(SUMIF(FRUIT;TRIM(MID(SUBSTITUTE(E3;",";REPT(" ";LEN(E3)));1+(ROW(INDIRECT("1:"&LEN(E3)-LEN(SUBSTITUTE(E3;",";""))+1))*LEN(E3))-LEN(E3);LEN(E3)));PRICE))
Мой аккаунт