HELP with DSum

Posted by JB on November 12, 2001 10:55 AM

Hello -

I really need help with DSUM. My goal is to find out how many minutes each employee spent on the phone per day.

Worksheet 1 has a list of indidviaul calls.
The collumns: Date Employee Caller Length of Call

on another worksheet, I am trying to perform a a DSUM How do I do this?

Posted by Barrie Davidson on November 12, 2001 2:02 PM

JB, why not use a pivot table to summarize your data. Have a look at my example and if you have any questions let me know via this board.

http://ca.geocities.com/b_davidso/Web_Page_Files/Excel/pivottable1.html

Regards,
BarrieBarrie Davidson