Countif range question

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
=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.
 
Back
Top