When are they used: COUNT :- To count the number of cells that contain numbers, use the COUNT function. COUNTIF :- To count cells based on one criteria (for example, less than 150), use the following COUNTIF function. COUNTIFS :- To count cells based on multiple criteria (for example, R Madrid and greater than 30), use the following […]
Category: Master Excel Formulas
AVERAGE , AVERAGEIF & AVERAGEIFS Functions
When are they used: AVERAGE :- You use the AVERAGE function in Excel to return the average (arithmetic mean) of the specified cells. Example 1. Calculating an average of numbers To find out an average of certain numbers, you can supply them directly in your Excel average formula.For example, =AVERAGE(1,3,4) returns 2.67 as the result. AVERAGEIF :- The classical […]
SUM, SUMIF & SUMIFS Functions
When are they used: SUM :- allows for the summation of a specific number of cells, both adjacent and non-adjacent. SUMIF :- allows for the summation of a range of cells that meet a specific criterion. SUMIFS :- allows for the summation of a range of cells that meet a number of different criteria.