Thread: Excel 2007 new formula: COUNTIFS

I thought this might make a nice tip... For those of you that have been as frustrated as me when trying to count cells which need to meet multiple criteria, there is a new formula that does this called COUNTIFS. The syntax is =COUNTIFS(range1, criteria1, range2, criteria2, range[n], criteria[n]). Note that this must be saved in .xlsx format!

For example, if you have a month number in column A and a weekday indication (marked with an X) in column B and you want to count only weekdays in this month, your formula might look like this: =COUNTIFS(A2:A65536,MONTH(TODAY()),B2:B65536,"X"). This will give you the number of cells meeting BOTH criteria, so that if you have cells in another month that are also marked with an X in column B they will not be counted! You can use this in any number of creative ways whenever you need to summarize data meeting multiple criteria. If you have Office 2007, I recommend that you give it a try

First, add a column to your list and make it a month. You can use the month formula to accomplish this. The goal being to have a month next to each date.
The month formula only works on a single cell, so that is probably why your formula is not working.

Now use the COUNTIF formula to count the number of cells in a certain month. COUNTIFS is mostly used in the case of multiple criteria... Like the number of sales over 100 dollars in a certain month.

I hope this helps!