Dragging formulas with a static cell reference??

[JMcDon1007]

Not sure if I described that right, but I have attached an example of what I need to do.

Essentially, I am dragging down cell F2 to cell F7, then changing the last cell reference in F7 to $F$11….then dragging it to F12 and repeating process. I have thousands of rows that need this calculation….

Is there any simple way to do this so I don't have to drag the cell down 5 places each time, and repeat?

Example2.xlsx

[etaf]

what is the formula you want to drag down
can you give a further example

Whats in F2
then whats in F7
?

[JMcDon1007]

Are you able to click on the example file? It's all in there. I have =C2/$C$6 in F2...drag that down to F7 (F6 is the total, which is 100%), then in F7 I change $C$6 to $C$11. ...and then repeat and repeat and repeat.........

[JMcDon1007]

Does anyone know how to do this??

[Jonmo1]

In F2 and Filled Down

=C2/LOOKUP("z",A$2:C6)

[JMcDon1007]

Jonmo,

Thank you for the reply. I see that formula works perfectly in the example I attached, but I have tried altering it for my true spreadsheet and I can't get it to work. I guess my example was not a true "example". I've attached an exact copy of the spreadsheet I'm working on. Would you be able to tell me what the correct formula would be to place in K2? Thanks for your help.

Example3.xlsx

[Jonmo1]

How would the formulas look from K2 down to K16 if you did them by hand?

[JMcDon1007]

Sorry.. Here's a spreadsheet with the formulas.

Thanks.

-JohnExample4.xlsx

[Jonmo1]

In K2

=H2/VLOOKUP("TOTAL",D2:H6,5,FALSE)

[JMcDon1007]

Thank you! I appreciate your help!

[Jonmo1]

Great, glad to help.