Thread: SUMPRODUCT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patricia
 
Posts: n/a
Default SUMPRODUCT

I am attempting to use the sumproduct function to determine the number of
ovetime hours worked by week. The following formula is returning a zero
value, which is incorrect:

=SUMPRODUCT((D$2:D$15000="20051009")*(E$2:E$15000= "L102")*(I2,I15000))

Seems pretty straightforward, but it's not working. Any help would be
appreciated.