This one's a little tricky...

Assuming the pay rate is in Column B and the hours worked are in Column
C and there are 8 rows of data from row 2 to row 9, type in B10:

=SUM(IF(C2:C9<0, B2:B9,""))

When you enter the formula, you'll get #VALUE.

Put your cursor in the cell with the formula (B10), press F2, then
press together Control-Shift-Enter. This tells Excel it's an array.
You should get the correct daily rate.


--
DataCollector
------------------------------------------------------------------------
DataCollector's Profile: http://www.hightechtalks.com/m368
View this thread: http://www.hightechtalks.com/t2295502