Sum if cells are equal to

To sum numbers based on cells being equal to a certain value, you can use either the SUMIF or SUMIFS functions. In the example shown, we are summing all sales in the West region. The formula in cell H6 is:
=SUMIF(region,"West",amount)
The formula in cell H7 is:
=SUMIFS(amount,region,"West")
Both formulas refer to the named ranges "region" (C5:C30) and "amount" (E5:E30).
Both formulas use built-in functions to calculate a subtotal, but the syntax used by SUMIF and SUMIFS is slightly different:
In both cases, note that the region "West" must be enclosed in double quotes, since it is a text value.
Whether you use SUMIF or SUMIFS (which can handle more than one criteria) is a matter of personal preference. SUMIFS was introduced with Excel 2007, so it's been around now for a long time.
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.