To count cells by using an Or criterion, you can sometimes use multiple COUNTIF functions. The following formula, for example, counts the number of sales made in January or February:

=COUNTIF(Month,”January”)+COUNTIF(Month,”February”)

You can also use the COUNTIF function in an array formula. The following array formula, for example, returns the same result as the previous formula:

{=SUM(COUNTIF(Month,{“January”,”February”}))}

But if you base your Or criteria on cells other than the cells being counted, the COUNTIF function won’t work. (Refer to Figure 17-2.) Suppose that you want to count the number of sales that meet the following criteria:

• Month is January, or
• SalesRep is Brooks, or
• Amount is greater than 1000

If you attempt to create a formula that uses COUNTIF, some double counting will occur. The solution is to use an array formula like this:

{=SUM(IF((Month=”January”)+(SalesRep=”Brooks”)+(Amount>1000),1))}

• Morning Update/ Market Thread 5/28 Good Morning,Equity futures are flat following yesterdays 284 point jaunt. That was a ridiculous 97% up day by volume on...
• Apple launches iPad Tablet Apple on Wednesday made its highly-anticipated announcement, launching the new iPad. Calling it a "truly magical and revolutionary product," Apple...
• Fun Facts about New Year's "Auld Lang Syne" was written by Robert Burns in 1741 and literally means "old long since," or "days gone by."...
• The After-Christmas Hangover Photo by littledan77 Yay!  Christmas is over!  Time to get my act back together.  You see, I've really slacked off...
• Paradise Point Marina, Stockton, CA Paradise Point Marina   Paradise Point Marina is located in Stockton, CA Phone: 209.952.1000 Boat Launch: Yes, but there is...