I have a workpaper that lists employees, their salary and the % of time they
work in a cost center. The employee's salary is multiplied by the % of time
to determine the cost center expense. There are over 200 employees that
divide their time to various cost centers.
What I need to is get a sum of the expnse by cost center. Is there a fuction
that would total the expense by cost center for a range.

Use SUMIF in this format
*=SUMIF(Range to look at for cost centre,Cost centre,Range to sum)*

Ross;244866 Wrote:
I have a workpaper that lists employees, their salary and the % of time
they
work in a cost center. The employee's salary is multiplied by the % of
time
to determine the cost center expense. There are over 200 employees that
divide their time to various cost centers.
What I need to is get a sum of the expnse by cost center. Is there a
fuction
that would total the expense by cost center for a range.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68295

Hi,

Please show us an example of the data layout. Probably you want SUMIF or
SUMIFS or SUMPRODUCT.

SUMIF(CostCenterRange,A1,SumRange)

where A1 has a cost center name or number or whatever.

Or you could use a pivot table.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Ross" wrote:

I have a workpaper that lists employees, their salary and the % of time they
work in a cost center. The employee's salary is multiplied by the % of time
to determine the cost center expense. There are over 200 employees that
divide their time to various cost centers.
What I need to is get a sum of the expnse by cost center. Is there a fuction
that would total the expense by cost center for a range.

Hi,

You can also use Data Subtotal. Bur before doing so, please sort the Cost
Centre column in ascending order.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Ross" wrote in message
...
I have a workpaper that lists employees, their salary and the % of time
they
work in a cost center. The employee's salary is multiplied by the % of
time
to determine the cost center expense. There are over 200 employees that
divide their time to various cost centers.
What I need to is get a sum of the expnse by cost center. Is there a
fuction
that would total the expense by cost center for a range.