SUMPRODUCT
Thank's, but that is just a typo. I have typed it as you indicated in my
spreadsheet. Any other suggestions????
"Gary''s Student" wrote:
Replace:
I2,I15000
with
I2:I15000
--
Gary's Student
"Patricia" wrote:
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.
|