# excel Summing formula examples

able 3-4 shows a number of formula examples that demonstrate a variety of summing
techniques.
Table 3-4: Summing Formula Examples
Formula Description
=SUMIF(Sales,”>200”) Sum of all Sales over 200
=SUMIF(Month,”Jan”,Sales) Sum of Sales in which Month = “Jan”
=SUMIF(Month,”Jan”,Sales)+SUMIF(Month,”Feb”,Sales) Sum of Sales in which Month =”Jan” or “Feb”

Chapter 3: Formula Tricks and Techniques 71
Formula Description
{=SUM((Month=”Jan”)*(Region=”North”)*Sales)} Sum of Sales in which Month=”Jan” and
Region=”North”
=SUMIFS(Sales,Month,”Jan”,Region,”North”) Sum of Sales in which Month=”Jan” and
Region=”North” (Excel 2007 and later)
{=SUM((Month=”Jan”)*(Region=”North”)*Sales)} An array formula that returns the sum of Sales
in which Month=”Jan” and Region=”North”
=SUMIFS(Sales,Month,”Jan”,Region,”<>North”) Sum of Sales in which Month=”Jan” and Region
<> “North” (Excel 2007 and later)
{=SUM((Month=”Jan”)*(Region<>”North”)*Sales)} An array formula that returns the sum of Sales
in which Month=”Jan” and Region <> “North”
=SUMIFS(Sales,Month,”Jan”,Sales,”>=200”) Sum of Sales in which Month=”Jan” and
Sales>=200 (Excel 2007 and later)
{=SUM((Month=”Jan”)*(Sales>=200)*(Sales))} An array formula that returns the sum of Sales
in which Month=”Jan” and Sales>=200