Automated solution required

[Guest]

I have a worksheet which is a timesheet and contains time recorded against projects for a week, broken down by Clients and Project Codes against which time gets recorded for each day of the week; in the last column the time is totalled up for the week

Basically I want to be able to be able to automate the process to find out how much time has been allocated to each Client

Is this best done via a macro or by some other method

 

[Frank Kabel]

Hi
have a look at the sUMIF function for this

--
Regards
Frank Kabel
Frankfurt, Germany

I have a worksheet which is a timesheet and contains time recorded

against projects for a week, broken down by Clients and Project Codes
against which time gets recorded for each day of the week; in the last
column the time is totalled up for the week.

Basically I want to be able to be able to automate the process to

find out how much time has been allocated to each Client.

 

[Debra Dalgleish]

You could use a pivot table to summarize the data. There are
instructions and links on Jon Peltier's web site:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

 

[Domenic]

I have a worksheet which is a timesheet and contains time recorded against
projects for a week, broken down by Clients and Project Codes against which
time gets recorded for each day of the week; in the last column the time is
totalled up for the week.

Basically I want to be able to be able to automate the process to find out
how much time has been allocated to each Client.

Is this best done via a macro or by some other method?

Hi Miller,

Assuming your timesheet is layed out something like this,

Date Clients Project_Codes Time_(Hrs)
5/1/2004 ABC Company PC100 3
5/2/2004 ABC Company PC120 5
5/3/2004 XYZ Company PC300 4
5/4/2004 XYZ Company PC300 2
5/5/2004 Smith Corporation PC400 3

try,

In cell A20 put ABC Company
In cell A21 put XYZ Company
In cell A22 put Smith Corporation

in cell B20 put this formula and copy down:

=SUMIF($B$2:$B$6,A20,$D$2:$D$6)

and you should get something like this:

ABC Company 8
XYZ Company 6
Smith Corporation 3

Hope this helps!