This function adds the cell using a given criteria.


  • array- is the array of cells you want to apply the condition.

  • condition - the condition used to determine which cells to add.
  • subrange - optional, it is the array of cells to sum together.If 'subrange' argument is omitted then SUMIF treats 'array' as 'subrange'.

Step 1 : In order to use the SUMIF formula, start with your edited Excellentable

Step 2 : Then type in the SUMIF Formula in the area you would like to display the outcome:

Step 3: Type in the complete SUMIF formula for a cell as shown below:

Step 4: Excellentable will generate the outcome when hitting enter. 



User does not have sufficient privileges to access this Content
Learn More