Calculating data using references from multiple worksheets

[CENorth7272]

I have a worksheet that tracks the time that customer service reps ar
on the phone. I have seperate sheets for each day, with summary sheet
at the end of the wkbk.

The daily sheets are set up as follows:

the left most column displays the time range (ex: 8:00, 9:00, 10:0
etc.
the next column displays the reps name (there are 7)
there are several info columns and some total columns
the rightmost column is a total talk time for the hour.

On one of the summary pages I want to be able to add the total for eac
hour per rep.

Besides just summing the info I want to be able to manipulate it i
other ways (subtracting, averages, etc)

I'm sure there has to be a function or way of doing things that I don'
know abou

 

[Jonathan Rynd]

Besides just summing the info I want to be able to manipulate it in
other ways (subtracting, averages, etc)

Look into the "Database" functions (Dfunctions): DSUM, DAVERAGE, DCOUNT,
DMAX, DMIN, DSTDEVP, DVARP.