Typo alert!
Assuming your miles to be surveyed in E2
Gord
On Tue, 16 Nov 2004 16:54:35 -0800, Gord Dibben <gorddibbATshawDOTca wrote:
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.
|