copying and holding certain cells in the function

R

rwong520

Hello all,

I'm having a slight problem with an Excel function that I hope someon
can help me with:

Here's the function that's in the cell:
= COUNT(G12:G66)/(((countbycolor(G5:G65
46,FALSE))+(countbycolor(A5:A65,40,FALSE)))

I then have to drag this cell to the right (thus copying the functio
to display the new calculated values). However, I'd like have everthin
shift (G12:G66 to H12:H66 to I12:I66 etc...) except A5:A65. I would lik
to hold this value as is. Is this possible???

Thank you very much in advance.
Regards,

Ron
 
T

tim m

Make A5:A65 an absolute cell location by putting $ in the formula like so:
$A$5:$A$65
You can manually type in the $ or click on that part of the formula and use
F4 to cycle through types of cell addresses.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

function work with manual update, fails with copy paste > 1 cell 4
Function or macro to copy cells... 0
How to copy a cell with an if-function? 2
Error copying cell containing 'IF' function and labels 2
Function not copying 2
Function dependent on prior cell value 5
Excel 97 error copying cell containing 'IF' function and labels 2
Macro for Time Stamping a Cell 2

Top