COUNTIF or COUNTBLANKIF

Hi all,

Im trying to count the cells in row where the cells fit criteria in column A

{=COUNT(IF((MONTH('Summary Cleaned up'!$A$4:$A$968)=D$2)*(YEAR('Summary Cleaned up'!$A$4:$A$968)=D$3),'Summary Cleaned up'!$B$4:$B$968))}

Col A houses a few years of consecutive dates
Col B contains values and blanks

D2 that I ref above contains the Month number and D3 has the year

A good example is where September 2009 has lets say 15 days with values the output would be 15 but with the above it seems to count the number of days that 30

I would be happy with countblank and have tried

{=COUNTBLANK(IF((MONTH('Summary Cleaned up'!$A$4:$A$968)=D$2)*(YEAR('Summary Cleaned up'!$A$4:$A$968)=D$3),'Summary Cleaned up'!$B$4:$B$968))}

but this does the same as the other formula..

Thanks a lot for your help.

Thanks Cutter,

Column A has dates from 01/09/2009 to present day so around 980 rows of data
Column B has values but there are a lot of missing entries,

Im trying to find out for the specified month and year how many missing entries there are in column B. So could be counting the blanks or counting the entries in B that fit the criteria specified in D2 and D3

If it wasnt for the need to specify the Month and Year as criteria from column A the

=COUNTBLANK('Summary Cleaned up'!B4:B33) works perfectly

Hope that helps with explaining it!

Looking at the formula its completely different to my original ones.

Regards

Yes, the formulas I gave are different. You are using array formulas but you may not need them.
Will this be used in an Excel version prior to 2007? If not, the last formula I gave you will tell you how many B cells are blank for the given time period.

You could also use a SUMPRODUCT() but try to stay away from array formulas unless they are necessary.

Thanks again for your reply

I am using version 2003 unfortunately, can you help me with the best one for that? Does the sumproduct approach work with an array?

Regards

Thanks for your help the first solution works great. Why us there three ;;; in the formula?
Regards