Excel financial problem - need assistance

K

kingcordova

Joined
Mar 30, 2012
Messages
1
Reaction score
0
I need some help with financial in excel 2003. I try to calculate my cost per week for my project .. I have 50 resources to calculate cost week per week

on column A1 I have rate per hours
on column B1 I have total cost per year
on column C1 I have the total hours per week the ressource his working. I calculate in FTE's = 1FTE = 40 hours

How can I do the sum per week - every week without having to do =sum(A1*B1*C1) for 50 persons

w81xRriKi+35QAAAABJRU5ErkJggg==
 
If the column format is consistent, and the rows contain contiguous data, write the formula in row 1 and double click the lower right hand corner of the cell. Or select the cell and drag the cell down across the range. Or select the column, including the cell with the formula and either right click>fill>down or ctrl>d.

Steve
 
Back
Top