Assuming your data below starts at A1

In D2: =B2*C2
Copy this down the column as far as you need,
In column D below your last cell from above: =SUM(D2:D??) changing the ?? to
the row above this cell.

HTH
--
Ian
--
"DonnaS" wrote in message
...
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