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).

### How to use MAXIFS function

MAXIFS function is considered to be one of the advanced statistical functions available in Excel.

### How to use SUMIFS (Multiple Criteria)

The SUMIF function is used to conditionally sum values based on certain criteria. Another version of that function is SUMIFS

### COUNTIFS Function (multiple criteria)

The COUNTIFS() function is an extended version of the COUNTIF() function which is used to conditionally count items/ cells based on certain criteria.