View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ross Ross is offline
external usenet poster
 
Posts: 152
Default Sum by Cost Center

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.