Category: Condition

Conditional functions helps you to customize your results in function of some criteria

Wildcard with COUNTIFS or SUMIFS

Wildcard characters with a COUNTIFS function

You can create complex criteria in your COUNTIFS or SUMIFS function with the wildcart.
The wildcards are specials characters to replace one or more characters in your string

Permanent link to this article: https://www.excel-exercise.com/wildcard-with-countifs-or-sumifs/

What is a Logical Test in Excel

When should you create a logical test? Creating a logical test is THE starting point for these 3 important functions in Excel: IF COUNTIFS SUMIFS What it a logical test Logical tests are everywhere. Is my salary higher than my colleague’s? Is my rent higher than my neighbour’s? Is the quantity in stock larger now …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/logical-test-excel/

Create test on String Length

Function IF with a test based on the length of the ID

The LEN function returns the number of characters is a cell. It’s very useful if you have to check the length of names, codes, references, …

Permanent link to this article: https://www.excel-exercise.com/create-test-on-string-length/

COUNTIFS – Count rows automatically in Excel

Avoid the filter to count rows When you want to count the number of rows corresponding to a specific criteria, many users use the tool Filter. For 1, 2 or 3 different criteria, you can work like that. But if you have to extract a lot of count of rows for many different criteria, the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/countifs-count-rows-automatically-in-excel/

Function COUNTIF

COUNTIF

A basic task with Excel is to count the number of rows for a specific criteria. The function COUNTIF do that easily 😃 Don’t use the filters Most of the Excel users, use the filter to count the rows. But this solution is really not convenient when you have to repeat this action for many …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/countif/

Function SUMIFS

SUMIFS, what’s for? When you have a list of data and you need to do the sum of few cells of this list, the SUMIFS function is the one to use. Well, in fact, there is 2 functions to do this: SUMIF SUMIFS SUMIF vs SUMIFS There is a big difference between SUMIF and SUMIFS. …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/sumifs/

Function SUMIF

The SUMIF function returns the sum of values for a specific criterion. This function is better than to perform a filter.

Permanent link to this article: https://www.excel-exercise.com/sumif/

Functions AND – OR

Formula to find people who get married with one child

The functions AND or OR are very useful if you have to create a test on more than 1 criteria. Have a look at the examples in this article

Permanent link to this article: https://www.excel-exercise.com/function-and-or/

Function IF – Examples

Result if the amount is correct or not

Discover all the tricks and mistakes you can have with the IF function

Permanent link to this article: https://www.excel-exercise.com/if-function-excel/