Funções CONT.SES, SOMASES e MÉDIASES no Excel | Planilha para Baixar | Exemplo Prático

🟢 LEARN EXCEL WITH ME AND BECOME A REFERENCE IN THE JOB MARKET: http://excelentejoao.com.br/sejaexcel... 🔵 DOWNLOADABLE SPREADSHEET: https://excelentejoao.com.br/wp-conte... #Excelentejoao #Excel #Dashboard In this Excel video lesson, we will learn how to perform the main Excel functions: SUMIF, COUNTIF, and AVERAGEIF. All these Excel formulas and functions can greatly help you in your daily life to automate tasks and processes, can help you in the job market, and can even help you in an Excel exam or an Excel test for a job interview. The SUMIF function can be used to sum the values ​​in a range that meet the criteria you specify. For example, suppose you want to sum only the values ​​greater than 5 in a column containing numbers. You can use the formula to perform this logical mathematical operation. The COUNTIF function in Excel is one of the statistical functions in Excel. We can use this formula to count the number of cells that meet a criterion. For example, to count the number of times a specific city appears in a customer list. The AVERAGEIF function in Excel returns the arithmetic mean of all cells in a range that satisfy a given criterion. The IF at the end of these functions indicates that we can insert a condition in the operation we are performing; that is, we can use only one criterion for the calculation. However, when we have IFS (with an 's' at the end), it means that we can insert one, two, or more conditions in this operation; that is, we can use several criteria to segment the calculation operation and obtain a more accurate result.