COUNTIF query

[digitallifeform]

Hey all

Hopefully a nice easy one....

We have a logging system, and the spreadsheet basically has the person
name doing a call, what the call is and how long it took. This is use
all day so loads of calls get logged by various people.

Say column A is Persons name and Column B is time spent. I need
calulation that checks how much time 'person 1', 'person 2', 'person 3
etc has spent on calls during the day and add's it all up.

Please can someone show me how to do this, i have tried a COUNTIF bu
cant quite get it to work.

Many thanks in advance.

Darren (digital_life_form)(don't ask

 

[Frank Kabel]

Hi
several ways:
one way using formulas
=SUMIF(A1:A1000,"personname1",B1:B1000)
and format the seulting cell as time

or you may have a look at pivot tables to create a report for all
persons. Have a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.cpearson.com/excel/pivots.htm
for some information to get started with pivot tables

 

[digitallifeform]

Thanks very much,