COUNT, COUNTIF & COUNTIFS Function

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

Read More

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

Read More