copying and holding certain cells in the function

  • Thread starter Thread starter rwong520
  • Start date Start date
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
 
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
 
Back
Top