What is SUMIF  Function

                      There are a few functions in Microsoft Excel that can be used to condense huge data sets for reports and analytics. SUMIF is one of the most helpful functions that can assist you in making sense of a confusing collection of disparate facts. It allows you to sum just the values that fit your criteria rather than the entire range of integers.

How to create Table 

=SUMIF(range, criteria, [sum_range])

Criteria are what make up the condition, and they can verify things like:

  • If a number is greater than another number >
  • If a number is smaller than another number <
  • If a number or text is equal to something =


Basic SUMIF formula

You start with defining the following arguments:

  • Range - a list of regions (A2:A8).
  • Criteria - "North" or a cell containing the region of interest (F1).
  • Sum_range - the sales amounts to be added up (B2:B8).

Putting the arguments together, we get the following formula:

  1. Select the cell M4
  2. Type =SUMIF
  3. Double click the SUMIF command


https://draft.blogger.com/blog/post/edit/8539569354072019066/2701999735271774083

You start with defining the following arguments:

  • Range - a list of regions (A2:A8).
  • Criteria - "North" or a cell containing the region of interest (F1).
  • Sum_range - the sales amounts to be added up (B2:B8).
https://draft.blogger.com/blog/post/edit/8539569354072019066/2701999735271774083



Now, we can examine the complete stats for all of the different Name & Marks Total:



https://draft.blogger.com/blog/post/edit/8539569354072019066/2701999735271774083

How to Sum With Formula