In the attached sample spreadsheet the percent column is blank in the customer totals row. What is the best method of inserting a formula to calculate the percent rather than manually entering the formula into each cell ? The formula for row 3 would be =G1/D1, row 5 =G5/D5, etc. The condition would be to enter the formula in column G for every row where the cell in column B is blank.The actual spreadsheet has over 500 rows. Thanks.