Excel: The most useful features

Excel provides numerous functions and formulas. You will find in this practical tip the most useful formulas and Tricks.

1. Function: fixed conditions for conditional sums

With the function "sum if", you can fixed the conditions for the conditional sums in Excel rules.

In our example, we will use in the cells A1 to A10 of the data in the cells B1 to B10 are the corresponding values used for the condition.
The task of the example is that all the values of column A should be summed, if the value of column B is greater than 10.
The formula would then look like this: "=sumif(B1:B10;">10";A1:A10)".
The value "B1:B10" defines the area that should be evaluated; subsequently, our condition: ">10" – i.e.: greater than 10. Here, you should note that the conditions must be written in quotation marks.
Finally, A1:A10 defines the range to be summed.

The function "count if" is, for example, to count all colored cells.

In our example, the cells D2 and D4 are red colored.
The formula would then look as follows: "=COUNTIF(D1:D4;1)". The "1" at the end of the search criterion, in our example, the color Red.
You will then receive in the cell in which you enter the formula, the respective result.
You can't, of course, only after the same colors, but also according to the same values, content and more.

The "IF" function you can use to check the arguments and then make a decision.

We have the following example: In cell C14, the value 10000 is.
We want to determine in the field C15 is the discount and use the formula "IF", which looks as follows in our example.
"=IF(C14