SumIF()_1

To calculate the sum of cells that meet a single condition we use------------------

• Sum()

• SumIF()

• Total()

SumIF() Criteria can be applied to ----------

• dates

• text

• numbers

• All that mentioned

Sum(),SumIf() are both -------------

• Math functions

• •Statistical functions

• •Logical functions

In SUMIF() Syntax

=SUMIF (range, criteria, [sum_range])

•sum_range - Is [optional] so if it's omitted, cells in --------------are summed.

• range

• no cells

• criteria

When typing a SUMIF() your criteria should be typed between----------

• / /

• ()

• {}

• " "

• ' '