Why is this giving me an error? It doesn't make sense!!!!

SUMPRODUCT(--('Raw - 2nd'!$C$2:$C$65536=$A37),--(MONTH('Raw -
2nd'!$b$2:$b$65536=4),'Raw - 2nd'!$J$2:$J$65536)

Column c is employee number
Column b is date range
Column j is $$ range

"Bob Phillips" wrote:

=SUMPRODUCT(--(APR_05!$C$2:$C$1000=$A37),--(MONTH(APR_05!$D$2:$D$1000=7),APR
_05!$J$2:$J$1000)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Curtis" wrote in message
...
SO far I have =SUMIF(APR_05!$C$2:$C$65536,$A37,APR_05!$J$2:$J$65 536)

this sums up the $$ by employee number. I need to add a formula that pulls
the $$ by the month as well .

"Matt Lunn" wrote:

Curtis,

An array formula would work here. Could you please give a little bit
more
detail about your data? You mention days. Does this mean the month is
to be
calculated from a date?

Thanks,
Matt

"Curtis" wrote:

I need to calculate the sum of number dependate on 2 conditions. One
condition is emplyee number ( in a column of many numbers) and the
other is
the month (in a column listed with many days)