How to subtract one field from another and sum a range of fields

Question

I created a form in Word that I converted to a fillable pdf form using the prepare form feature for a template for a mileage log. I would like to create a formula that calculates miles driven for each row where it takes the odometer reading at destination point and subtracts the odometer reading at starting point. I know how to create the formula for the first row, however my table has 60 rows and I would like to copy the formula in the first cell to the cells in the other rows. Is there anyway to do this or do I have to create the formula for the cells in the other rows one by one? Also, I would like to create a cell that totals the miles driven for all of the rows in the miles driven column that will be labeled total mileage. Is there a formula that would allow me to do that? I have attached a template of the form I created to this post. If I can have assistance on this it would be much appreciated.

Nesa Nurani · Accepted Answer

Here is your file with scripts included https://drive.google.com/uc?export=download&id=1Q-pZ7JGqdMZpC6tRHTtY52BilQ9Rq_C2

For miles driven, script is in "Miles DrivenRow1" field under calculate tab -> custom calculation script.

For total mileage, script is in "Total Mileage" field under calculate tab -> custom calculation script.

Since you only have 22 fields in your sample, I set that number in scripts so you can test it, and since you said you have total of 60 rows, in both scripts change 22 to 60 for your original file.

JR Boulay · Answer

-----------

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded