Using excel to track billable hours

[kwinsw]

Hi,

I have a spreadsheet which I use to track the jobs we do every month. My manager has asked me to modify the sheet to track billable hours. The amount we can bill varies depending on who’s doing the work.

What I’d like to do is create a formula which I can use to track who is working what hours. I can then get the worksheet to calculate how much we can bill for each person.

What I’d like to dos is use a formula that specifies something like this:

“Look at cells B5 to B12. Every time you see the initials RM in one of these cells, look at the corresponding cell in row C. Add up all the values in these cells in column C.”

I know it’s a complicated one. Any help much appreciated.

Thanks

kwinsw

 

[SkipVought]

Hi,

You ought to be able to use the PivotTable Wizard to sum for all or specific initilas. If you have REAL DATES, you can use Group & Outline in the Date Field to Group by Month.

An experienced user could generate such a report in about 15 seconds. It VERY powerful!

Skip,

_[red][/red]

 

[hisbadbanana]

Enter this formula where you want the answer:

=SUMIF(B5:B12,"RM",C5:C12)