DumDum was thinking very hard :
Hi,

i have an excel file that is manually updated and calculated that marks
what product our software developers have worked on during the day

what this file, has is different worksheets for each month (so each file
has 12 worksheets as each one is represented by each month), and within
each month
- is a list of staff names going vertically in the first column
- each day of that specific month going horizontally in the first row
- on each day we mark a reference code that enables us to determine
which product a certain staff member worked on which

then at the end of every financial year we can determine the overall
cost of what each product has costed us for the year, but this is manual
calculation by going through each worksheet and marking the count

somehow, we would like to automate the calculation of the amount of
times a staff member works on a product for the past year

i am struggling with which function i should be looking at? its been a
while since i have done smething this complicated in excel and my
knowledge isnt where it used to be.

hopefully some help is provided, it would be appreciated

Why not simply SUM the columns for each month and insert a summary
sheet to collect the total of each product? (This assumes the product
list is identical on every sheet including the summary)

Otherwise, more info is required to know exactly how staff updates the
sheets. Do they 'clock' on/off each work instance or use formula-style
entry (ie: "=<timeworked+<timeworked...)? Do you want to summarize by
product, staff, or both? (We aren't mind readers!)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc