Calculation Conundrum



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
.



Relevant Pages

  • Re: userform tabs
    ... A multipage control has tabs ... on the bottom. ... What do you mean by a 5 page userform. ... > and similarly with the prev button it would switch to the prev page with ...
    (microsoft.public.excel.programming)
  • Re: Sort a sparse matrix in descending order
    ... the sorted matrix so that all zeros are at the bottom of the matrix. ... Geo ... > % the engine ... Prev by Date: ...
    (comp.soft-sys.matlab)
  • Re: Adding and Multiplying Question
    ... on the bottom right of the cell with the above formula ... and drag down to row 260. ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Selling a car to the scammers.
    ... > read from top of the page to bottom, rather like most writing really. ... Prev by Date: ...
    (uk.rec.cars.classic)
  • Re: designing a form that will update each month
    ... Remove "AYN" from email to respond ... >I am trying to take an existing form we use and name the critical fields in ... Each month there are columns at the bottom of the form and when I put ... Prev by Date: ...
    (microsoft.public.excel.programming)