Statistical Function - SUMIF

If you want to calculate the total numerical values of a data set based on their individual category, then the SUMIF function is the one for you!

The video shows the SUMIF function in use.

The final written calculation is below:

=SUMIF(C:C,H4,F:F)

In this formula, C:C is the range of cells that may contain the item we want to count, i.e apple.

H4 is the cell that contains the criteria we need to count.

F:F is the second range, that contains the numerical values we want to sum as a result of the criteria identified by H4.