Excel is a mathematical spreadsheet where you can perform multiple calculations with the help of Excel Formulas. These are automated formulas which refreshes automatically once you refresh your data in a given range. Here you should know about “Excel Ranges” before starting to use Excel Formulas.
You can SUM (Add) multiple numbers in a given range of excel and get the total amount with just few clicks. So Let’s learn this most basic Excel formula
This formulas can be used to calculate the total of any range/cell reference given in excel. We can use multiple range to find the Total/Sum of given values or we may enter/select values to get the total.
So if you do simple math 2+2=4, you may use this formula to do the same in excel
Things To Remember
– This formula should strictly be used with Numbers only
– If this formula is showing #Ref error, it means that you have deleted or added a Row
– If this formula is showing #N/A error, it means that your range might contain text
All above mentioned formulas are using the relative references which means that these are dynamic ranges, so if you copy these formulas or paste it somewhere else or drag in rows or columns, ranges will be automatically updated relatively.
So when your Excel Ranges are fixed, you should make excel ranges Fixed/Absolute range. In order to make excel ranges absolute, you can fix those excel range by putting “$” i.e. if you want to fix the columns only, you should use
=Sum($A2:$A10) >> Here we are fixing the column "A" or
=Sum(A$2:A$10) >> Here we are fixing the Rows by putting $ front of 2 and 10
=Sum($A$2:$A$10) >> Here we are fixing both Rows and Columns by putting $
Excel Function DATE While using Microsoft Excel, you must have got the situation where you need to use the Date function. Date function is one of the common and most used function in Excel that…
How to Change TEXT into DATE Format Microsoft Excel “DATEVALUE” is the very useful where dates are available as TEXT and need to convert them to proper DATE format. DATEVALUE function helps to convert the…
You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…
RANK function performs the Ranking in a range or list of numbers. Function returns the rank position and can assigned as highest or lowest value as 1st Rank
https://youtu.be/HmJL_y93pAs WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date. Syntax:…
SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.