top of page


The SUMIF function allows us to calculate the sum of a range based on specific criteria. This function enables us to sum a range based on criteria found either within the same range or in a different range.

The syntax of the SUMIF function is: =SUMIF(range,criteria,[sum_range])

  1. range – This is the range in which our criteria will be checked.

  2. criteria – This is the criteria we’ll check

  3. [sum_range] – This is the range we’d like to sum (only for the cells that matched our criteria).

bottom of page