View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Griffey5 Griffey5 is offline
external usenet poster
 
Posts: 13
Default Adding columns using dates, but getting wrong data


A B C

1/9/08 7
1/9/08 8 7
1/9/08 3 3
1/10/08 5
1/10/08 10 7

If column A and B are my data and I use the following formula to calculate
the hours of OT for each day =SUMIF($A$2:$A2,A2,B$2:B2)-8 to get the totals.
How do I get it to only give me the hours over 8 for each day and not the
totals.
With the above formula I am getting -1, 7, 10, -3, 7 I need to get the
totals as above.

Any suggestions