Answer the question
In order to leave comments, you need to log in
Excel/LibreOffice: Why doesn't the SUMIF (SUMIF) function work?
Screenshot: pastenow.ru/HOA0
For example, line F6:
=SUMIF($C$3:$C$100;"*продукты*";$B$3:$B$100)+SUMIF($C$3:$C$100;"*обед*";$B$3:$B$100)
=SUMIF($C$3:$C$100;"*Мегафон*";$B$3:$B$100)+SUMIF($C$3:$C$100;"*Yota*";$B$3:$B$100)+SUMIF($C$3:$C$100;"провайдер";$C$3:$C$100)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question