Calculating data using references from multiple worksheets

  • Thread starter Thread starter CENorth7272
  • Start date Start date
C

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
 
Besides just summing the info I want to be able to manipulate it in
other ways (subtracting, averages, etc)
Click to expand...

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