How to use sumif formula?

Sumif is a summing operation that adds only those values which meet a required condition. The condition to be met may be in a same column or row or in a different column or row. The syntax for Sumif formula is as follows:

1. Criteria indicates the condition put forth by the user which needs to be looked for in a particular column or row.

2.  Range indicates the range of rows or column in which the criteria needs to be looked up and satisfied.

3.  Sum_range is the range of values that needs to be summed if the criteria is found in the Range. The Sum-range can be the Range itself or it can be other cells corresponding to the Range columns or rows.

Lets now go through an example.

I have a table which is used to enter time required for 4 different processes. the column E is used to calculate the total of the entries in the columns B, C and D respectively. Now my requirement is to get the total of individual processes in the grid arrangement on the top two rows 1 and 2. And there is no better option than to use Sumif option in this case

Now following the syntax of the Sumif formula, In the cell C1 type the following: =SUMIF(A5:A18,"DETAILING",E5:E18)

 Similarly modify the above shown formula in the other 3 cells by changing the process names. 

=SUMIF(A5:A18,"FINAL CHECK",E5:E18)

=SUMIF(A5:A18,"SELF CHECK",E5:E18)

=SUMIF(A5:A18,"ENGINEERING",E5:E18)

  Enter some values under respective cells and check.

Try it!