Trying to easily copy formulas using the "$" absolute but not working

[Dietfarm]

Here is what I have:

My spreadsheet consist of Columns B - AF with customer names as my heading rows in 1 and 2- Rows 3 - 8 are numbers of items each customers purchased. In Column A11 - A40 I have specific calculations for the totals for each customer - Example A11 is a calculation for Column B3-B9 which is =B$3/5000+B$4/5000+B$5/2000+B$6/1000+B$7/500+B$8/100.....The absolute "$" is there so I can copy the formula to A12-A40 where the row numbers stay the same but the column letters will change so A12 looks like... =C$3/5000+C$4/5000+C$5/2000+C$6/1000+C$7/500+C$8/100 then A13 looks like =D$3/5000+D$4/5000+D$5/2000+D$6/1000+D$7/500+D$8/100 then so on and so on down to A40...but the columns letters are not changing...WHAT AM I MISSING to make all these copy correctly?

[shg]

Post a workbook and explain in context.

[ChemistB]

If you copy down a column, the column letter will stay the same.

Maybe in A11
=SUM(INDEX($B$3:$AF$8,,ROW(A1))
copied down
Does that work for you?

Edit; Never mind. Doesn't take into account the different amounts you are dividing by.
Hmmm

[Dietfarm]

Thanks ChemistB but you are correct - It didnt work ;/
Shg - New to the group not sure how the posting a workbook works - having no luck [table="width: 500, class: grid, align: left"]

[ChemistB]

Go Advanced > Manage Attachments

[ChemistB]

Probably a better way but..
=INDEX($B$3:$AF$8,1,ROW(A1))/5000 +INDEX($B$3:$AF$8,2,ROW(A1))/5000 +INDEX($B$3:$AF$8,3,ROW(A1))/2000 +INDEX($B$3:$AF$8,4,ROW(A1))/1000 +INDEX($B$3:$AF$8,5,ROW(A1))/500 +INDEX($B$3:$AF$8,6,ROW(A1))/100

[Dietfarm]

Here is a sample of the spreadsheet

[ChemistB]

Funny, I thought spreadsheet extentions end in xls, not png.
In any case, did you try the formula I gave in #6 in B16 copied down?

[Dietfarm]

Funny, I thought spreadsheet extentions end in xls, not png.
In any case, did you try the formula I gave in #6 in B16 copied down?

I did try it and no it didnt work...PNG on the spreadsheet - it was a snip of the spreadsheet.

[ChemistB]

Here's an example of how that formula works compared to how I think your old formula worked. Let me know specifically what results you expect to see in there instead of what is in there. Thanks

[Dietfarm]

Here's an example of how that formula works compared to how I think your old formula worked. Let me know specifically what results you expect to see in there instead of what is in there. Thanks

that worked!!! Awesome...I copied the formula to mine and it was perfect - looks like the other formula but it didnt work for whatever reason but this one is perfect YOUR THE BESTEST thanks for your help!!!

[Dietfarm]

that worked!!! Awesome...I copied the formula to mine and it was perfect - looks like the other formula but it didnt work for whatever reason but this one is perfect YOUR THE BESTEST thanks for your help!!!

However can you explain what you did so I can recreate the formula?