# 12 Excel Equations You Absolutely Must Learn

As one of the best data crunching tools in the market, Microsoft Excel is also one of easiest to learn due to its clean user interface and a variety of prebuilt options meant to provide convenience to a user to crunch data. Excel equations are one of the options available in the excel tool.

Excel equations are very handy prebuilt formulas in excel. You can easily find formulas for most of the basic operations. Once you go through this article, you will easily understand the basic excel equations and how to use it to get the desired result.

## 1. SUM(number 1, number 2, ..)

This excel equation takes the range of numbers and provides the summation of all the numbers.

E.g. If you want to know the sum of 1, 2, and 3, you can use the formula as follows:

=SUM(1,2,3) Output 6

Note: You can also give cell range e.g. A1: A3 instead of numbers.

## 2. AVERAGE(number 1, number 2, ..)

This excel equation takes the range of numbers and gives the average of all the numbers.

E.g. If you want to know the average of 1, 2 and 3, you can use the formula as follows:

=AVERAGE(1,2,3) Output 2

## 3. MAX(number 1, number 2, ..)

This excel equation returns the largest value among all the arguments.

E.g. If you want to know the max of 1, 2, and 3, you can use the formula as follows:

=MAX(1,2,3) Output 3

## 4. MIN(number 1, number 2, ..)

This excel equation returns the smallest value among all the arguments.

E.g. If you want to know the max of 1 2 and 3, you can use the formula as follows:

=MIN(1,2,3) Output 1

## 5. COUNT(range of cells)

This excel equation counts the number of cells that contain the number. It ignores blank and empty cells.

E.g. If A1=1, A2=3, A3=”ABC”, A4=”def”, A5=”xyz” then =COUNT(A1: A5) will be 2.

## 6. COUNTA(range of cells)

This excel equation count the number of cells that are not empty.

E.g. If A1=, A2=3, A3=”ABC”, A4=”def”, A5=”xyz”, then =COUNTA(A1: A5) will be 4.

Check out my COUNTA post for or more examples of how to use this function.

## 7. TODAY()

This equation is part of Date & Time Excel equations as it gives the output for the present day’s date.

E.g. If today’s date is 4/17/2018 then =TODAY() will return 4/17/2018.

## 8. NOW()

This equation returns the today’s date as well as current time.

E.g. If today’s date is 4/17/2018 and the current time is 4:00 PM, it will return 4/17/2018 16:00.

## 9. RAND()

This excel equation returns a randomly generated number between 0 and 1 (and changes each time when you refresh)

E.g. =RAND() (Potential) Output .2232

## 10. RANDBETWEEN(lower number, upper number)

This excel equation gives you the randomly generated number which falls between the specified numbers.

E.g. =RANDBETWEEN(1,100) (Potential) Output 63

## 11. COUNTIF(range, criteria)

This excel equation count the number of cells which meets the given criteria.

## 12. COUNTIFS(range 1, criteria 1, range 2, criteria 2)

This excel equation works same as COUNTIF but it allows multiple criteria.

Check out my post on the logic behind COUNTIF and COUNTIFS for more examples of how to use these functions.

These are some very basic formulas and you will easily remember just by practicing a few times with some data. Note that you don’t have to remember the exact syntax. Excel will provide you the suggestion once you start typing.

Happy working with Excel!