Date Lookup issue

[Eigtball]

OK Here is the issue.

I want to perform a COUNTIF on a Range of Cells on one work sheet that display DONE. But I only want it to count the DONE's that fall on a certain month.

Also that Month would of course change.

Here is the Present formula but I need it with a Date.

=COUNTIF('Uncoached List'!G:G,"Not Done")

 

[Brian from Maui]

OK Here is the issue.

I want to perform a COUNTIF on a Range of Cells on one work sheet that display DONE. But I only want it to count the DONE's that fall on a certain month.

Also that Month would of course change.

Here is the Present formula but I need it with a Date.

=COUNTIF('Uncoached List'!G:G,"Not Done")

Try,

=SUMPRODUCT(--(MONTH(MonthRange)=1),--(Range="Done"))

Where 1 equates to January. Ranges must be of the same size and no whole column references. Substitute the correct worksheet name and ranges.

Edit for Year test,

=SUMPRODUCT(--(MONTH(MonthRange)=1),--(--YEAR(MonthRange)=2005),--(Range="Done"))

 

[Eigtball]

OK I tried that Formula and the Result was #Name?

I don't know what I am doing wrong.