Sum Formulas

1. SUM 

The SUM function is the first must-know formula in Excel. It usually aggregates values from a selection of columns or rows from your selected range.

Example:

=SUM(number1, [number2], …)

=SUM(E2:E14)

2. AUTO SUM

For quick and everyday tasks, the AutoSum function is your go-to option. So, navigate to the Home tab, in the far-right corner, and click the AutoSum option. Then click the caret to show other hidden formulas. This option is also available in the Formulas tab first option after the Insert Function option.

Use Short curt Key: 

SUM - (ALT+=)

3. SUMIF

If you want, you can apply the criteria to one range and sum the corresponding values in a different range.

Example:

=SUMIF(range,critera,[sum_range]

=SUMIF($L$4:$L$54,$R8,$P$4:$P$54)

4. SUMIFS

The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria.

Example:

=SUMIFS (sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, criteria_range3, criteria3, …

=SUMIFS($AA$4:$AA$54,$W$4:$W$54,$AC6,$Y$4:$Y$54,AF$4)

5. SUMIFS - Find the data in month as per full date

Find the salary as per month in the given data

Example:

=SUMIFS($AK$4:$AK$19,$AJ$4:$AJ$19,$AO6,$AM$4:$AM$19,AP$4)