Условные функции с критериями - Функции Excel (5)

Hello! In this video tutorial, we will learn how to use the following eight Excel functions: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIF, MINIF. All these functions are united by the fact that they perform predefined actions (summation, calculating the average value, counting and finding the minimum or maximum value) on a series of values ​​based on the fulfillment of specified criteria. In fact, these functions are a kind of combination of the IF function with one of the corresponding basic functions - SUM, AVERAGE, COUNT, and so on. Since the principle of operation of these conditional functions is the same, we will consider all these functions at once, in one bundle. Enjoy watching! 😊 File from the video for exercises: https://drive.google.com/file/d/1CeD_... Want to support my channel? You can do so using the "Sponsorship" function:    / @bilyalkhassenov