Thread: Excel 2003
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pana 139
 
Posts: n/a
Default Excel 2003

I hope that someone can help with this data collection

A1 B1
a 4 digit no a 1 digit no
A2 B2
a 4 digit no a 1 digit no

In another cell for data collection I need to have the data form cell A1 and
at the side a total of B1 or B2 etc etc if a1,A2 etc are the same number
I hope that I have explained this properly, what it is for is a time sheet
where the same job ( a 4 digit no) across a number of days has had various
hours spent at this task. I need to have a collection athe base of the report
totalling all the hours spent on a particular job