#1
|
|||
|
|||
How do I autofill my formula?
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. |
#2
|
||||
|
||||
You need to use absolute reference to cell G2, like this in E4 then pull down:
=D4/$G$2 |
#3
|
|||
|
|||
Yes, that did the trick, many thanks
|
#4
|
||||
|
||||
Glad I was able to help .
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Autofill data from web | irisha | Excel Programming | 10 | 09-02-2016 05:30 PM |
Creating AutoFill form - AutoFill information depending on a selection. | RyanHarper | Word | 3 | 06-15-2015 01:01 PM |
Autofill | Stacybug1 | Excel | 2 | 01-28-2015 01:04 PM |
Autofill Automation | Parkiee1981 | Excel | 4 | 03-15-2013 01:24 PM |
AutoCorrect Or AutoFill | Johnny thunder | Outlook | 0 | 05-02-2011 03:37 PM |