Excel IFS Function Tips

Averaging The 5 Lowest Values In Your Data!

Let’s assume you are a math’s teacher interested in finding the average of the math’s score of last five students – he is interested in finding why they are performing poor. How will he proceed?

Using SUMPRODUCT() To Validate Multiple Criteria In Columns

We have studied and used SUMIFS() and SUMPRODUCTS() function with their appropriates use. Just to recall, SUMIFS() work great when our data is in the shape of list or is in column.

How To Use MINIFS Function In Excel

The MINIFS function is an advanced statistical function, which is only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).

How To Use IFS Function In Excel

IFS function is a new function added to Excel and only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).

Using COUNTIF To Count!

COUNTIF() family of functions is amongst the most frequency used family of functions in Excel.

Understanding And Doing Better With SUMIF Function

SUMIF() functions is among the most commonly used functions in excel. Whenever ever we have to sum against a given criteria we revert to this function, be the criteria be only one or more then one (for more then one criteria’s we use SUMIFS(), just another function of this family).