barc0d3guy
New Member
- Joined
- Oct 23, 2013
- Messages
- 14
Hi, there. I am trying to copy a formula from a cell on my excel sheet and then drag it across in the columns. When I do that, it adds up on the columns and I want the formula to add to the rows.
In this workbook on, sheet FeedBack, I am trying to calculate values on cell B5 to AP5, by referring to the values from cell c11 to c41. The formula i am using in cell b5 is =(C11/3)*0.475+($D$11). Now when i drag this formula until AP5, instead of taking values from c11:c41 it takes values from c11:aq5.
So is there anyway to do this without adding the formula manually in every cell??
Any help will be appreciated.
Thanks in advance.
In this workbook on, sheet FeedBack, I am trying to calculate values on cell B5 to AP5, by referring to the values from cell c11 to c41. The formula i am using in cell b5 is =(C11/3)*0.475+($D$11). Now when i drag this formula until AP5, instead of taking values from c11:c41 it takes values from c11:aq5.
So is there anyway to do this without adding the formula manually in every cell??
Any help will be appreciated.
Thanks in advance.