Skip to main content



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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.