How to calculate values in multiple values with multi conditions

try
=sumproduct(--(monthrange=month),--(Namerange=name),datarange)
The ranges in each section must be the same size and cannot be full columns
or rows:

"Curtis" wrote:

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

It give me a error with formula


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

Any thoughts?

ce

"bj" wrote:

> try
> =sumproduct(--(monthrange=month),--(Namerange=name),datarange)
> The ranges in each section must be the same size and cannot be full columns
> or rows:
>
> "Curtis" wrote:
>
> > I need to calculate the sum of number dependate on 2 conditions. One
> > condition is emplyee number ( in a column of numbers) and the other is the
> > month (in a column listed as days)

try
=sumproduct(--(monthrange=month),--(Namerange=name),datarange)
The ranges in each section must be the same size and cannot be full columns
or rows:

"Curtis" wrote:

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

It give me a error with formula


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

Any thoughts?

ce

"bj" wrote:

> try
> =sumproduct(--(monthrange=month),--(Namerange=name),datarange)
> The ranges in each section must be the same size and cannot be full columns
> or rows:
>
> "Curtis" wrote:
>
> > I need to calculate the sum of number dependate on 2 conditions. One
> > condition is emplyee number ( in a column of numbers) and the other is the
> > month (in a column listed as days)

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

try
=sumproduct(--(monthrange=month),--(Namerange=name),datarange)
The ranges in each section must be the same size and cannot be full columns
or rows:

"Curtis" wrote:

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

It give me a error with formula


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

Any thoughts?

ce

"bj" wrote:

> try
> =sumproduct(--(monthrange=month),--(Namerange=name),datarange)
> The ranges in each section must be the same size and cannot be full columns
> or rows:
>
> "Curtis" wrote:
>
> > I need to calculate the sum of number dependate on 2 conditions. One
> > condition is emplyee number ( in a column of numbers) and the other is the
> > month (in a column listed as days)