Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

SUMIF

Description: Adds the cells specified by the criteria.

Syntax: SUMIF(Range, Criteria, [Sum_range])

Remarks:

Example:

Suppose A1:A4 contain the following property values for four homes: $100,000, $200,000, $300,000, $400,000, respectively. B1:B4 contain the following sales commissions on each of the corresponding property values: $7,000, $14,000, $21,000, $28,000.

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.