CountIf formula question
 

I have a spreadsheet in Excel 2003 and Column A has dates in the following
formats: 1/1/2007. I'm trying to create a Formula that counts how many
cells have January on them, so I created something like this:
Countif(A1:15), 1/2007, but is not working because it returns 0. is there a
way to Count the number of cells with January on them?

Thanks,

CountIf formula question
 

=SUMPRODUCT(--(A1:A15<""),--(MONTH(A1:A15)=1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Marilyn" wrote in message
...
I have a spreadsheet in Excel 2003 and Column A has dates in the following
formats: 1/1/2007. I'm trying to create a Formula that counts how many
cells have January on them, so I created something like this:
Countif(A1:15), 1/2007, but is not working because it returns 0. is there
a
way to Count the number of cells with January on them?

Thanks,

CountIf formula question
 

try
=sumproduct(--(month(A1:A15)=1))

"Marilyn" wrote:

I have a spreadsheet in Excel 2003 and Column A has dates in the following
formats: 1/1/2007. I'm trying to create a Formula that counts how many
cells have January on them, so I created something like this:
Countif(A1:15), 1/2007, but is not working because it returns 0. is there a
way to Count the number of cells with January on them?

Thanks,

CountIf formula question
 

Thank you ALL for the quick response, both methods worked

:)

"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A15<""),--(MONTH(A1:A15)=1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Marilyn" wrote in message
...
I have a spreadsheet in Excel 2003 and Column A has dates in the following
formats: 1/1/2007. I'm trying to create a Formula that counts how many
cells have January on them, so I created something like this:
Countif(A1:15), 1/2007, but is not working because it returns 0. is there
a
way to Count the number of cells with January on them?

Thanks,