G
Guest
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
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