SUMPRODUCT Issue

I am trying to set up a summary page from data collected
over the past few months. The 2 colums of data that I am
trying to reference are a date colum in a mm/dd/yyyy
format. The other is a a validated drop down list.

My objective is to find out how many of responses from
the drop down list occuredd in the diffente months.
Specific dates are irrelevant at this point.

Right now I am try to use a SUMPRODUCT statement and
having no luck. Mostly getting a 0 as a product.

Here is what I pretty much have so far, any help would be
great as I have been at this for a while:

=SUMPRODUCT(((Data!C2:C1000=BK2)+(Data!C2:C1000=BK 3))*
(Data!A1:A1000=MONTH(x))

C colum is my data validated colum that references BK2:BK6
A colum is my date colume, I have formatted the cells to
be in the date format vs. General.
x is the Month Number i.e. 12 is December which is where
my Data starts.

Any ideas would be great.
Thanks in advance.

Adam

See answers in misc.

Andy.

"Adam Lauzon" wrote in message
...
I am trying to set up a summary page from data collected
over the past few months. The 2 colums of data that I am
trying to reference are a date colum in a mm/dd/yyyy
format. The other is a a validated drop down list.

My objective is to find out how many of responses from
the drop down list occuredd in the diffente months.
Specific dates are irrelevant at this point.

Right now I am try to use a SUMPRODUCT statement and
having no luck. Mostly getting a 0 as a product.

Here is what I pretty much have so far, any help would be
great as I have been at this for a while:

=SUMPRODUCT(((Data!C2:C1000=BK2)+(Data!C2:C1000=BK 3))*
(Data!A1:A1000=MONTH(x))

C colum is my data validated colum that references BK2:BK6
A colum is my date colume, I have formatted the cells to
be in the date format vs. General.
x is the Month Number i.e. 12 is December which is where
my Data starts.

Any ideas would be great.
Thanks in advance.

Hi Adam
see your replies in Excel.misc

P.S.: please don't multipost


--
Regards
Frank Kabel
Frankfurt, Germany

Adam Lauzon wrote:
I am trying to set up a summary page from data collected
over the past few months. The 2 colums of data that I am
trying to reference are a date colum in a mm/dd/yyyy
format. The other is a a validated drop down list.

My objective is to find out how many of responses from
the drop down list occuredd in the diffente months.
Specific dates are irrelevant at this point.

Right now I am try to use a SUMPRODUCT statement and
having no luck. Mostly getting a 0 as a product.

Here is what I pretty much have so far, any help would be
great as I have been at this for a while:

=SUMPRODUCT(((Data!C2:C1000=BK2)+(Data!C2:C1000=BK 3))*
(Data!A1:A1000=MONTH(x))

C colum is my data validated colum that references BK2:BK6
A colum is my date colume, I have formatted the cells to
be in the date format vs. General.
x is the Month Number i.e. 12 is December which is where
my Data starts.

Any ideas would be great.
Thanks in advance.