Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/myscript/public_html/classes/classdb.php on line 42
SUMIF Function / Formula in Microsoft Excel 2007 | Video Tutorial

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