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