This Week I thought I would do 5 really great formulas that will save you time.
So here we go Excel formulas you should definitely know:-
The formula looks like this: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5)
The SUM formula does exactly what it says on the tin, allowing you to add 2 or more numbers together or even cell references if you use those lots.
The different examples above take you through the options, you can have normal numbers in there separated by commas and it will add them together for you, you can have cell references and as long as there are numbers in those cells it will add them together for you as well, 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, for example =SUM(A1:B5)
The formula looks like this: =COUNT(A1:A10)
This formula is great it counts the number of cells in a range that have numbers in them yes you heard correct only those cell with numbers though. If you want to count other cells check out number 3.
The formula looks like this: =COUNTA(A1:A10)
Now this formula counts the number of non-empty cells in a range. So It will count cells that have numbers and/or any other characters in them the “COUNTA” formula works with all types of data.
The formula looks like this: =LEN(A1)
Ok with the two above we have counted ranges of cell to see how many is there using “LEN” will count the number of characters in a cell. Now you have to be careful though this includes the spaces as these are characters too.
The formula looks like this: =TRIM(A1)
Now I know I have been really frustrated when using data typed in by others with extra spaces at the end of cells so “Trim” gets rid of any space in a cell, except the single ones between words.