Hi can somebody help me with this:
I have huge data and I have to count it this way
=countif(c1:c2, 1)/a2
=countif(c1:c3, 1)/a3
=countif(c1:c4, 1)/a4
One end of range is unchanged and other end is growing, is there any way to
make this process aoutomatic? If I hold and drag it down with mouse both
ranges are growing, but I need only one rage to grow.

Thanks for help

=countif(c1:c2, 1)/a2

Put it like this in the starting cell:
=COUNTIF(C$1:C2,1)/A2
Copy down. The $ sign will fix it to row1.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Judoguy" wrote:
Hi can somebody help me with this:
I have huge data and I have to count it this way
=countif(c1:c2, 1)/a2
=countif(c1:c3, 1)/a3
=countif(c1:c4, 1)/a4
One end of range is unchanged and other end is growing, is there any way to
make this process aoutomatic? If I hold and drag it down with mouse both
ranges are growing, but I need only one rage to grow.

Thanks for help