SUMIF Function

The SUMIF function calculates and finds the total of numbers, which match the given criteria.


=SUMIF(Range, Criteria, Sum range)
Whereas "Range" is the range of cells to be checked, "Criteria" is the condition that defines which cells are to be added and the "Sum range" is the range to be added if the cells match the given criteria.

Video Tutorial:

Let us find the sum of the given set of numbers based on condition, using the SUMIF function, with the help of the below video.

Learn MS Excel

Ask Questions

Ask Question