SUMIF function

Category:Mathematics and trigonometrics

English name:SUMIF

That makes?

Sums the values ​​in a range as long as they meet the specified conditions.

Syntax

ADDIF (range, condition, [range_sum])

  • range (Required ): The range of cells to which the sum condition will apply.
  • condition (Required ): The condition that must be met to be taken into account for the sum.
  • sum_range (Optional ): The range of cells that will be summed. If it is omitted, the values ​​of the first argument will be added.

Examples

ADDIF (A1: A5, ”> 3 ″) = Sum the values ​​in A1: A5 that are greater than 3
ADDIF (A1: A5,”> 3 ″, B1: B5) = Sum the values ​​in B1: B5 as long as the values ​​in A1: A5 are greater than 3

Leave a Comment