View Single Post
  #1   Report Post  
Curtis
 
Posts: n/a
Default Calculating the sum with multiple conditions

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