Hi folks, in the attached spreadsheet example, what I aim to do is log the number of people canvassed daily in column D, and then have column E calculate the percentage of total people canvassed that day based on the total people number in cell G2. I have formatted all the cells in column E to percentage and one decimal place. The formula I entered in cell E4 was then "=D4/G2" and it correctly displays as 51.8% in cell E4. But how do I auto-fill this formula for the following days? (E5 to E12)? If I copy cell E4 and do a straight paste to cell E5 in attempts to enter the formula "=D5/G3", when it should be entering "=D5/G2". This results in a "#DIV/0!" error in cell E5 when the value I want displayed in here should be 56.5%.

Likewise dragging the right hand side of cell E4 down to Cell E5 produced the same error "=DIV/0!". Paste formula has the same result and paste link displays 51.8% when it should be 56.5%.

There must be an easier way to do this besides creating a new column beside each row and putting the number 2000 in all rows in that column. Thanks for your help.

Attached Files

PERCENTAGE EXAMPLE.xlsx (10.2 KB, 6 views)