Sumif function in Excel

The structure of the Sumif function is Sumif(range, criteria, sum range)

How to use the Sumif function in Excel

  • Go to the Excel function assistant
  • Search for the Sumif function
  • Select the range
  • Lock the cells
  • Select the criteria
  • Select the sum range. The sum range is the data that we like to add up. The range and the sum range both need to be the same seize
  • Lock those cells
  • Hit Enter


No comments yet.

Leave a Reply