"The formula you typed has an error"



"RagDyer" wrote:

It looks OK to me.

What error are you getting?

I would check to make sure the dates in Column B are true dates.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Curtis" wrote in message
...
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

I need to calculate the sum of $$ dependate on 2 conditions. One
condition is emplyee number ( listed in column c - many numbers) and the
other is the month (listed by day in column b)


Anyone

Thanks in advance