Automated solution required

M

Miller

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
 
F

Frank Kabel

Hi
have a look at the sUMIF function for this

--
Regards
Frank Kabel
Frankfurt, Germany

Miller said:
I have a worksheet which is a timesheet and contains time recorded
Click to expand...
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
Click to expand...
find out how much time has been allocated to each Client.
 
D

Domenic

Miller said:
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?
Click to expand...

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!
 
Top