Create a total based on multiple conditions
Use the following formula to calculate the total value of cells F5:F25, where B5:B25 contains "Northwind" and the range C5:C25 contains the region name "Western".
=SUM(IF((B5:B25="Northwind")*(C5:C25="Western"),F5 :F25))
To calculate the total value of cells F5:F25, where B5:B25 contains either "Northwind" or "Terra Firm", use the following formula.
=SUM(IF((B5:B25="Northwind")+(B5:B25="Terra Firm"),F5:F25))
Both of these formulas are array formulas and must be entered by pressing CTRL+SHIFT+ENTER. Learn about array formulas.