Assuming your miles to be surveyed in D2

Assuming daily miles entered in column A starting in A2

In B2 enter =IF(A2="","",A2/$E$2) to return daily percentage.
Drag/copy down column A

In C2 enter =IF(A2="","",SUM($A$2:A2)/$E$2) to return a running total.
Drag/copy down Column B

Note the dollar($) signs. These must be left as is.

Gord Dibben Excel MVP




On Tue, 16 Nov 2004 14:34:01 -0800, doddlebugger
wrote:

I have a number of miles to be surveyed and each day I will keep track of
these miles I want a formula to calculate the precent of miles surveyed.