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.