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
1. =SUM(Range1,Range2……)
2. =SUM(Range1,Range2……)
3. =SUM(Range Start:Range End) i.e. =SUM(A2:A4)
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 $
The ROMAN function in Excel converts numbers into Roman numerals. It’s useful when you need to display numbers in the Roman numeral format, such as for dates, titles, or other specific purposes. The function allows you to choose how “traditional” or simplified the Roman numeral should be. To use the ROMAN function, you just need to enter the number you want to convert, and Excel will do the rest
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
Watch: How to use MODE & MODEIF Function in Excel? What is MODE Function? In Excel, the “MODE” function is a statistical tool that identifies and returns the most frequently occurring value within a set…
Do you work with lots of data in Excel? Sorting, summarizing, and organizing information can take time. You may have used features like outlines, subtotals, or pivot tables before. But now, there’s an even simpler…
Watch: How to use WORKDAY & WORKDAY.INTL Function in Excel? What is WORKDAY Function? The WORKDAY function in Excel calculates a date that is a specified number of working days before or after a given date. It…
This guide shows how to use the nested IF function in Excel to check several conditions. You will also learn about other functions that can be to use than a nested formula.
When you want to make decisions in Excel, you often use an IF formula. It checks if something is true, then gives one result if it is and another result if it isn’t. If you need to check more than one thing, you can put many IFs inside each other.
Although using multiple IFs is common, it’s not the only way to check several conditions in Excel. This guide will introduce you to some easier and useful alternatives.