# Excel Function of the Month – SUMIF

## SUMIF

Description

The SUMIF function adds the number of cells in a range that meet certain criteria.

Usage

Using the SUMIF function allows one to add together numbers in a range where the numbers are related to a certain condition. For example, in the picture below, we can add up how much just all the apples cost even though there are several other items in the range as well.

The SUMIF function has 3 ‘arguments’ that must be supplied:

• The range to look in
• What to look for in the specified range
• The range to add up the relevant numbers

Check out my Excel posters for your classroom

I have created posters that you can stick up in your class. There are 33 posters. Below is an index of what functions are available and a sample sheet (to the right) showing what the posters look like. You can purchase them from the Tech Teachers online shop.

Functions covered

AND, AVERAGE, CONCATENATE, COUNT, COUNTA, COUNTBLANK, COUNTIF, DATE, FIND, INT, LARGE, LEFT, LEN, LOWER, MAX, MEDIAN, MID, MIN, MODE, NOW, OR, POWER, RAND, RANDBETWEEN, RIGHT, ROUND, SMALL, SUM, SUMIF, TIME, TODAY, UPPER, VLOOKUP