| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
"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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
