SUMIF function


Add cells specified by a given condition or criteria.



=SUMIF( rangecriteria[sum_range] )


required arguments:

range The range of cells that you want to apply the criteria against.
criteria The criteria used to determine which cells to add.


optional arguments:

[sum_range] The cells to add together. If sum_range is omitted, the cells in range are added together instead.