Can PLUS add more than two numbers at once?

No, PLUS accepts exactly two arguments. To sum three or more values, use the SUM function instead: =SUM(A1, B1, C1) or =SUM(A1:A5).

What's the difference between PLUS and the + operator?

Functionally, there is no difference—both return identical results. PLUS is a function wrapper around addition, useful when working with dynamic formula composition or function-based calculations.

Does PLUS work with negative numbers?

Yes, PLUS handles any numeric values, including negative numbers. =PLUS(-5, 10) returns 5, and =PLUS(-100, 30) returns -70.

Why use PLUS instead of simply using the + operator in my formula?

PLUS is useful in scenarios where function syntax is required, or when building more complex formula compositions. For simple addition, the + operator is typically more readable and is the standard choice in most spreadsheets.

PLUS function

PLUS returns the sum of two numbers, making it ideal for combining values in retail calculations and data analysis.

=PLUS(number1, number2)

Generate a PLUS formula

Describe what you need. The generator will reach for PLUS where PLUS is the right tool, and tell you when it is not.

Arguments

How PLUS reads its arguments

Argument	Required	Description
number1	Required	A required number or reference to a cell containing a number. If text that cannot be interpreted as a number is provided, returns #VALUE!.
number2	Required	A required number or reference to a cell containing a number. If text that cannot be interpreted as a number is provided, returns #VALUE!.

Returns

A number equal to the sum of number1 and number2.

Availability

Excel: Not available · Google Sheets: Supported

Worked examples

1. Sum units from two of the same rep's orders

Order ID	Rep	Units
001	Alice	5
005	Alice	6

=PLUS(C2, C3)

Result: 11

Alice's sales log shows two orders with 5 and 6 units respectively. PLUS adds them to reveal that Alice sold 11 total units across these two transactions.

2. Calculate combined revenue from multiple orders

Order ID	Units	Unit Price
001	5	24.99
002	3	15.50

=PLUS(B2*C2, B3*C3)

Result: 171.45

Order 001 generated 5 × 24.99 = 124.95 in revenue, and order 002 generated 3 × 15.50 = 46.50. PLUS combines these calculations to show total revenue of 171.45 from both orders.

3. Add order revenue and commission earned

Order ID	Units	Unit Price	Commission
001	5	24.99	12.50

=PLUS(B2*C2, D2)

Result: 137.45

Order 001 produced revenue of 5 × 24.99 = 124.95, and the rep earned 12.50 in commission. PLUS totals these two components to calculate 137.45 as the complete transaction value.

Common errors

Which PLUS error are you seeing?

Error	Why it happens	How to fix it
#VALUE!	One argument contains text that cannot be converted to a number, such as =PLUS('North', 100) where 'North' is a region name instead of a numeric value.	Ensure both arguments are numbers or cell references containing numbers. Replace text values with their numeric equivalents or reference the correct numeric cell.
#NULL!	Arguments use incorrect range syntax with a space instead of a comma separator, such as =PLUS(A1:A2 B1:B2) which Google Sheets cannot parse.	Separate the two arguments with a comma: =PLUS(A1:A2, B1:B2). PLUS requires exactly two arguments divided by a comma.
#NAME?	The function name is misspelled or unrecognized, such as =PLS(10, 20) or =PLUS_(5, 3), or the spreadsheet application doesn't support PLUS.	Verify the function name is exactly PLUS (no underscores or typos) and confirm you're using Google Sheets or another application that supports this function.

Tips and when to use something else

PLUS is functionally identical to the + operator—=PLUS(10, 20) returns the same value as =10+20. Use whichever feels most natural for your formula.
For adding more than two numbers, switch to SUM function: =SUM(A1:A10) is simpler and more efficient than nested PLUS calls.
PLUS works seamlessly with cell references and expressions, enabling dynamic formulas that update whenever source data in your sales log changes.
If you need to add numbers only when certain conditions are met, use SUMIF or SUMIFS instead of PLUS to filter before calculating.

Related functions

SUMSUM adds numeric values in a range or multiple ranges, ignoring text and empty cells, and returns the total sum.MINUSSubtracts the second number from the first number and returns the resulting difference, commonly used to find gaps between values.MULTIPLYMULTIPLY returns the product of two numbers, commonly used to calculate total inventory value, costs, or other scalar quantities in spreadsheets.DIVIDEDIVIDE returns the quotient of one number divided by another, with support for error handling to prevent division-by-zero crashes.IFThe IF function returns one value if a condition is true and another (or nothing) if it is false, letting you branch logic in a cell.

Frequently asked questions

Can PLUS add more than two numbers at once?: No, PLUS accepts exactly two arguments. To sum three or more values, use the SUM function instead: =SUM(A1, B1, C1) or =SUM(A1:A5).
What's the difference between PLUS and the + operator?: Functionally, there is no difference—both return identical results. PLUS is a function wrapper around addition, useful when working with dynamic formula composition or function-based calculations.
Does PLUS work with negative numbers?: Yes, PLUS handles any numeric values, including negative numbers. =PLUS(-5, 10) returns 5, and =PLUS(-100, 30) returns -70.
Why use PLUS instead of simply using the + operator in my formula?: PLUS is useful in scenarios where function syntax is required, or when building more complex formula compositions. For simple addition, the + operator is typically more readable and is the standard choice in most spreadsheets.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17