Question

Difference Between sum() function and Sumif() function

Answer 1

SUM FUNCTION -The quickest way to sum a range of cells is to use the AutoSum button. It automatically enters a SUM function in the selected cell. The SUM function totals one or more numbers in a range of cells.

SUMIF FUNCTION -The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 2000). The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel.

Answer 2

The difference between the sum() function and the sumif() function is as follows:

• There are some functions in excel for totalling the range of cells

• The sum() function in excel is one of the important functions which means the summation of many cells without any condition prescribed.

• Example:- sum() function can be used in calculating the total marks of students.

• On the other hand, the sumif() function contains some conditions in calculating the sum of many cells.

• Example:- sumif() function. can be used for calculating total Sundays in a year.