Calculate cost per week for project

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

See excel spreadsheet for a better picture related to my question.

First, change those '40 hours' cells to a number: 40.

Second, use SUMPRODUCT.

=SUMPRODUCT($B$2:$B$18,C2:C18) in cell C19, then drag that over to the other cells in row 19.

Note, however, that your sheet did not quite match your description. The sheet had column A with people's names in it.

Pauley

Try this array formula

=SUM(IF(C2:C18<>"",(SUBSTITUTE(C2:C18," hrs",""))*($B$2:$B$18)))

as an array formula, you commit it with Ctrl-Shift-Enter not just Enter

Thanks it works !

excel question.JPG

can you help please, i need the weekly cost(A) from the date in (B) + (C) to go into D
:confused