Excel Important Formula which is asked by interviewer.
Excel Important Formula 1. SUM Formula: =SUM ( 5, 5) or =SUM ( A1, B1) or =SUM ( A1 : B5) The SUM formula does exactly what you would expect. It allows you to add 2 or more numbers together. You can use cell references as well in this formula. 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 there are 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. 2. COUNT Formula: =COUNT ( A1 : A10) 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 cells where there are numbers. **Learn more about the COUNT function in this on-demand, online course. FREE preview** 3. COUNTA Formula: =COUNTA ( A1 : A10)