Compare SUM vs SUBTOTAL

2 vs

Compare SUM vs SUBTOTAL side-by-side — differences, popularity and recommendation

Presets: VLOOKUP vs XLOOKUP SUM vs SUMIFS INDEX vs MATCH vs XLOOKUP IF vs IFS vs SWITCH COUNT vs COUNTA vs COUNTIF AVERAGE vs AVERAGEIF vs AVERAGEIFS MAX vs LARGE vs MIN TEXT vs TEXTJOIN vs CONCAT FILTER vs SORT vs UNIQUE ROUND vs ROUNDUP vs ROUNDDOWN

All functions Pick at least 2 functions

Feature

Math & Trig

=SUM()

★ Winner

Syntax

Math & Trig

=SUBTOTAL()

Syntax

Category

Math & Trig math-trig

Popularity

100 / 100

80 / 100

Views

◉ 101 views

◉ 63 views

Output

Number

Version

All versions

Volatile

Dynamic Array

Description

How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.

Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.

Syntax

=SUM(number1,[number2],...)

=SUBTOTAL(function_num,ref1,[ref2],...)

Arguments

2 Arguments

number1 number2-255 (Optional)

3 Arguments

function_num ref1 ref2 (Optional)

Examples

Tips

★ Recommendation — Winner: =SUM()

=SUM() is recommended based on higher popularity, newer version and Dynamic Array support.

Winner: =SUM()