Calculation Conundrum
- From: DonnaS <DonnaS@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 7 Sep 2005 10:46:06 -0700
I'm sure there is a simple solution, but after hours of research...I need help.
There are staff members planned for a project and hours that need to be
multiplied times the rate to give a dollar figure per person with a bottom
line total for the dollars. There may be anywhere from 1-50 people assigned
to a project so not every line is filled in. For example:
Name hours Rate Total
Chris 50 $100 $5000
Joe 10 $125 $1250
? #VALUE
? #VALUE
Total #VALUE
What is the best way to handle this? Thank you for your kind assistance.
DonnaS
.
- Follow-Ups:
- Re: Calculation Conundrum
- From: Ian
- Re: Calculation Conundrum
- Prev by Date: Re: keep specific cells from being changed.
- Next by Date: Converting an object in Excel into an actual cell
- Previous by thread: keep specific cells from being changed.
- Next by thread: Re: Calculation Conundrum
- Index(es):
Relevant Pages
|