Calculating the sum with multiple conditions
 

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

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

Works fine for me, having said that, do you really need +65500 rows? It
doesn't
make sense unless you have that many values and if you do that formula will
be very slow

Try to enter the formula with the help of the mouse, that way you'll get the
apostrophes etc for free (I noticed a small b and that looks like manual
entering

I use the mouse to select for instance C2:C6 and then I just add 5536 after
the 6

--
Regards,

Peo Sjoblom

(No private emails please)


"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

I thinks so. I receive data twice a week in files that are cut and paste into
one file. This is done until the worksheet is full then I insert another
worksheet into the workbook to continue.

"Peo Sjoblom" wrote:

Works fine for me, having said that, do you really need +65500 rows? It
doesn't
make sense unless you have that many values and if you do that formula will
be very slow

Try to enter the formula with the help of the mouse, that way you'll get the
apostrophes etc for free (I noticed a small b and that looks like manual
entering

I use the mouse to select for instance C2:C6 and then I just add 5536 after
the 6

--
Regards,

Peo Sjoblom

(No private emails please)


"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

"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