How to calculate values in multiple values with multi conditions

G

Guest

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)
 
G

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate sum of numbers with conditions 12
Calculating the sum with multiple conditions 4
SumIf 10
SUMIF with multiple conditions 3
SUMIF w/multiple conditions 1
SUMIF based on 2 conditions 3
Sum If Multiple Conditions 3
average on 2 conditions 6

Top