I basically have 4 tables: 1) the main road and each driveways distance in
miles 2) a pro-rata table that has the share (in miles) that each represents
depending on which is plowed 3) the hours plowed 4) the table I originally
posted that computes totals in dollars per event using pro-rata mileage
multiplied by an hourly rate

Formatting: all are number, rounded to two places except for a the total row
in table 4 that is currency, rounded to two places.

Formulas: table 2 has "=c+12+c+13" to arrive at a total mileage then
"=c22/c25" for individual values divided by the this total for the pro-rata
scenarios that can change and table 4 uses these values to apply to the hours
to arrive at individual breakdown in hours then sums them in the column, then
applies the hourly rate by "=g16*55"

Thanks.

"JE McGimpsey" wrote:

What values and formulas are in the input cells?

Are any of the cells Text (which SUM() ignores)? Pasted-in data is a
frequent source of text-entered "numbers".

In article ,
Earl wrote:

Thanks, but I have basically the same results. I can understand a penny but
some are 20 cents off.