Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to calculate values in multiple values with multi conditions
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) |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
How to sum values in multiple worksheets | Excel Worksheet Functions | |||
Multiple X-Axis Values | Charts and Charting in Excel | |||
How do you calculate the difference between two values within a p. | Excel Discussion (Misc queries) |