counting entries in a given month

[cwik]

I have a database that has a list of dates (A) and Profit (B)

So I wanna count all the entries made in a given month.

What I'm trying now is:

=COUNTIF($A$2:$A$600,(($A$2:$A$600<>"")*(MONTH($A$2:$A$600)=1)*(YEAR($A$2:$A$600)=2007)))

where column A = date

However, this is just returning "0".

Am I one the right track, or am I not thinking about this correctly??

[Paul]

cwik, try using sumproduct, like this:

=SUMPRODUCT(--($A$2:$A$600<>""),--(MONTH($A$2:$A$600)=1),--(YEAR($A$2:$A$600)=2007))

[cwik]

humm, plugged that in, and it just gave me #value.

Anyhow, if done right, wouldn't that just add up all the dates? I just want them counted, i.e. ten entries = 10.

[Paul]

I entered dates in column A, and numbers in column B. That's the example you gave.

When I enter

=SUMPRODUCT(--($A$2:$A$600<>""),--(MONTH($A$2:$A$600)=1),--(YEAR($A$2:$A$600)=2007))

in cell D2, it tells me the count of entries for January 2007 (Month=1, Year=2007).

When I enter

=SUMPRODUCT(--($A$2:$A$600<>""),--(MONTH($A$2:$A$600)=2),--(YEAR($A$2:$A$600)=2007))

in cell D3, it tells me the count of entries for February 2007 (Month=2, Year=2007).

Etc..

I have attached an example.

[cwik]

Thanks, I got it.

I realized my database doesn't start till row 15, and while I changed the column I did not edit the range... so well there ya go.

Thanks a lot. Very helpful.

[Paul]

Great, glad to hear it worked.