countif forumla

[keilah]

Hi

It is possible to count the number of entries in a particular month with out doing a pivot table.....via forumla......say i wanted to know the number of clients that fell in the month february any year from 2000 to date?

thanks

[anandbohra]

try this
=SUMPRODUCT(--(MONTH(A1:A4)=2),--(YEAR(A1:A4)>2000))

countif will do only if u have one criteria say date is more than certain date
=countif(range,criteria)
=COUNTIF(A:A,">01/01/2000")

but here u have multiple criteria i.e. month of Feb & year more than 2000
so better use sumproduct

[RV6555]

If you have Excel2007 you can use countifs. I have had some troubles with sumproduct, you might also concatenate and then use countif.
Col A Col B Col C
Feb 2000 =Concatenate(A+B)

[anandbohra]

yes i know in Excel 2007 there are some added functions like countifs, sumifs, averageifs etc
but sumproduct will solve your problem in better way.

but u still didnt mention your exact problem.

r u getting the required output or we r just discussing various other way to get required output.