In our daily life, we always use excel to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions. To maintain our work, we always need some formula to make us easier to keep it useful. Here is some important formula that we must use to any job-
- SUM formula
- COUNT formula
- COUNTA formula
- LEN function
- TRIM function
- Right, LEFT and MID function
- If Statements
- SUMIF, COUNTIF and AVERAGEIF
- CONCATENATE function
The SUM formula does exactly what you would expect. It allows you to add 2 or more numbers together
Formula:=SUM(5,5) or =SUM(A1,B1) or =SUM(A1,B5)
The Above shows you different examples. You can have numbers in there separated by commas and it will add them together for you. You can have cell references and as long as numbers in those cells it will add them together for you, or you can have a range of cells with a colon in between the 2 cells, and it will add the numbers in all the cells in the range.
ALT+=(Equal to sign): The Shortcut automatically selects the range of cells above the formula up to an empty cell. If used after applying a filter on a column, this shortcut will give the subtotal of the filtered values for that column.
The count formula counts the number of cells in a range that have numbers in them. This formula only works with numbers, though, It only counts the cell when there are numbers.
Counts the number of non-empty cells in a range. It will count cells that have numbers and or any characters in them.
It counts the number of empty cells no matter the data type.
The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.
Notice the difference in the formula results: 10 characters without spaces in between the words, 12 with spaces between the words, 12 with spaces between the words.
In the next blog, we will discuss the remaining formula for you. So keep looking. Till then.