Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Sum and multiple conditions across different sheets | Excel Worksheet Functions | |||
Vlookup with multiple conditions | Excel Worksheet Functions | |||
SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions |