Spread 8.0 Documentation
SUMIF
Support Options
Formula Reference > Built-In Functions > SUMIF

Glossary Item Box

SUMIF


Name

Sumif

Description

Adds the cells using a given criteria.

Syntax

SUMIF(array,condition,sumrange )

Remarks

This function has the following arguments:

Argument Description
array Range of cells to check; each cell in the array can be a double-precision floating-point value or an integer value
condition Condition that determines which cells are added, as text, number, or expression
sumrange [Optional] Range of cells to add; if omitted, then all the cells in the array are added

Data Type

Accepts numeric data for array and sumrange. Accepts text, numeric, or expression data for condition. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

SUMIF(A1:B7,">150",C1:C11)
SUMIF(A1:A9,">150")

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.