Addition Formula in Microsoft Excel

Microsoft Excel is the most widely used number processing application. Learning formulas and addition in Microsoft Excel is actually easy. You only need to memorize the formula that will be used to do the addition.

By knowing the addition formula in Microsoft Excel, it can make it easier to speed up your work in processing numbers. The following is an article on how to easily create addition formulas in Microsoft Excel.

Using the + icon

The way you can do this to create an addition formula in Microsoft Excel is to use the plus (+) icon. This method is the most basic in addition in Microsoft Excel. You just need to write it in the formula bar column.

The writing is the same as the usual addition. You only need to enter the number and add the + symbol. Don't forget to add the "=" symbol at the beginning.

Using the SUM function

The second way that you can do to create an addition formula in Microsoft Excel is to use the SUM function. This method is quite efficient if you want to add up in large numbers and sequentially. The SUM function is provided by Microsoft Excel. It's easy, you just need to enter the formula =SUM(column you want to add: column you want to add up)

Using the SUMIF Function

Almost the same as the SUM function, the SUMIF function is used to perform sums but with certain criteria. Make sure, the value to be added up must meet the requirements.

Using the SUMIFS Function

Unlike SUMIF, this function is more focused on sums with more than one criterion. If in SUMIF you have to add up with certain conditions and criteria, the SUMIF function allows you to add up data based on more than one criterion or condition.

Use SUBTOTALs

The subtotal function can be used if you want to sum data by filtering it first. This function is quite efficient to use to calculate the total of a data.

SUBTOTAL function formula

=SUBTOTAL(function_number,reff,…)

Here's an easy way to make addition formulas in Microsoft Excel that you can apply. After reading this, you don't need to be confused anymore if you want to add in Microsoft Excel. Hopefully the above article is useful, yes!