Could be, maybe try

=SUM(A2:G2,H2*I2/100)

--
HTH

Bob Phillips

"Lonz" wrote in message
...
Thanks for your help. But I still having problems.

Here is the actual order of the columns.

Date, Description, Hotel, Transportation, Fuel, Meals, Phone,
Entertainment, Misc, and Total. I inserted # of Miles and Mileage Rate
(40.5 cent). between Misc and Total. I tried the formula you gave me, but
I
don't think the total was correct. I enter the mileage rate as
40.5...could
that be the problem.

Please let me know. Thanks again.




"RagDyeR" wrote:

With existing fields in A to G,
And mileage in Column H, and mileage rate in Column I,

Revise your SUM() formula to something like this:


--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Lonz" wrote in message
...
I'm new at this. I added two field to an Excel Expense Report Template,
but
I
do not know have to what formula to use to calculate the totals.

These are the fields: Hotel, Transportation, Fuel, Meals, Phone,
Entertainment, Misc, and Total. But I inserted these two fields: # of
Miles
and Mileage Rate (40.5 cent). I am not sure how to include the two added
field into the formula.

Please Help.