### COUNTING FORMULA EXAMPLES

- =COUNTIF(Region,”North”)
- =COUNTIF(AvgCost,3400
- =COUNTIF(Sales,”>500”)
- =COUNTIF(Sales,”<>100”)
- =COUNTIF(Area,”?????”)
- =COUNTIF(Region,”*h*”)
- =COUNTIFS(Month,”Jan”,Sales,”>200”)
- {=SUM((Month=”Jan”)*(Sales>200))}
- =COUNTIFS(Month,”Jan”,Region,”North”)
- {=SUM((Month=”Jan”)*(Region=”North”))}
- =COUNTIFS(Month,”Jan”,Region,”North”)+COUNTIFS(Month,”Jan”,Region,”South”)
- {=SUM((Month=”Jan”)*((Region=”North”)+(Region=”South”)))}
- =COUNTIFS(Sales,”>=300”,Sales,”<=400”)
- {=SUM((Sales>=300)*(Sales<=400))}

Counts the number of rows in which the value in Region is “North

Counts the number of rows in which AvgCost equals 400

Counts the number of rows in which Sales greater than 500

Counts the number of rows in which Sales <> 100

Counts the number of rows in which Area contains five letters

Counts the number of rows in which Region contains the letter H (not case sensitive)

Counts the number of rows in which Month = “Jan” and Sales > 200

An array formula that counts the number of rows in which Month = “Jan” and Sales > 200

Counts the number of rows in which Month = “Jan” and Region = “North”

An array formula that counts the number of rows in which Month = “Jan” and Region = “North”

Counts the number of rows in which Month = “Jan” and Region = “North” or “South”

An array formula that counts the number of rows in which Month = “Jan” andRegion = “North” or “South”

Counts the number of rows in which Sales is between 300 and 400

An array formula that counts the number of rows in which Sales is between 300 and 400

### SUMMING FORMULA EXAMPLES

- =SUMIF(Sales,”>200”)
- =SUMIF(Month,”Jan”,Sales)
- =SUMIF(Month,”Jan”,Sales)+SUMIF(Month,”Feb”,Sales) or “Feb”
- =SUMIFS(Sales,Month,”Jan”,Region,”North”)
- =SUMIFS(Sales,Month,”Jan”,Region,”North”)
- {=SUM((Month=”Jan”)*(Region=”North”)*Sales)}
- =SUMIFS(Sales,Month,”Jan”,Region,”<>North”)
- {=SUM((Month=”Jan”)*(Region<>”North”)*Sales)}
- =SUMIFS(Sales,Month,”Jan”,Sales,”>=200”)
- {=SUM((Month=”Jan”)*(Sales>=200)*(Sales))}
- =SUMIFS(Sales,Sales,”>=300”,Sales,”<=400”)
- {=SUM((Sales>=300)*(Sales<=400)*(Sales))}

Sum of all Sales over 200

Sum of Sales in which Month = “Jan”

Sum of Sales in which Month =”Jan”

Sum of Sales in which Month=”Jan” and Region=”North”

Sum of Sales in which Month=”Jan” and Region=”North”

An array formula that returns the sum of Sales in which Month=”Jan” andRegion=”North”

Sum of Sales in which Month=”Jan” and Region <> “North”

An array formula that returns the sum of Sales in which Month=”Jan” and Region <> “North”

Sum of Sales in which Month=”Jan” and Sales>=200 (Excel 2007 only)

An array formula that returns the sum of Sales in which Month=”Jan” and Sales>=200

Sum of Sales between 300 and 400 (Excel 2007 only)

An array formula that returns the sum of Sales between 300 and 400