copying and holding certain cells in the function
 

Hello all,

I'm having a slight problem with an Excel function that I hope someone
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 function
to display the new calculated values). However, I'd like have everthing
shift (G12:G66 to H12:H66 to I12:I66 etc...) except A5:A65. I would like
to hold this value as is. Is this possible???

Thank you very much in advance.
Regards,

Ron.


--
rwong520
------------------------------------------------------------------------
rwong520's Profile: http://www.excelforum.com/member.php...o&userid=36893
View this thread: http://www.excelforum.com/showthread...hreadid=566081

copying and holding certain cells in the function
 

Hi,

I've not heard of the countbycolor function and my Excel doesn't
recognise it - but I am guessing that if you used the function

= COUNT(G12:G66)/(((countbycolor(G5:G65,
46,FALSE))+(countbycolor($A$5:$A$65,40,FALSE)))

it should achieve what you want?

What is the function used for by the way? Is it an addin?

Regards

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=566081