Logo 
Search:

MS Office FAQ

Submit Interview FAQ
Home » Interview FAQ » MS OfficeRSS Feeds

What is the different between SUM and SUMIF?

  Shared By: Shruti Sharma    Date: Jan 20    Category: MS Office    Views: 1575

Answer:

SUM : Adds all the numbers in a range of cells. E,g SUM(3, 2) equals 5, If cells A2:E2 contain 5, 15, 30, 40, and 50: SUM(A2:C2) equals 50, SUM(B2:E2, 15) equals 150.

SUMIF : The SUMIF worksheet function checks for a value within a range and then sums all the corresponding values in another range. SUMIF has three arguments: the range to be checked, the value to check for within the range (the criteria), and the range containing the values to be summed.

=SUMIF(range,criteria,sum_range)

Share: 
 

Didn't find what you were looking for? Find more on What is the different between SUM and SUMIF? Or get search suggestion and latest updates.


Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].


Tagged: