Continued Formula

Hi,

Apologies if this has already been answered. I don't know what criteria this query would fall under.


I’m trying to figure out how you can make a formula continue from where the last one ended.

E.g.

=IF((P23:P32,2)+(COUNTIF((P33:P42),1))

When dragging the formula down it makes

=IF((P24:P33,2)+(COUNTIF((P34:P43),1))

But I need it to be:

=IF((P43:P52,2)+(COUNTIF((P53:P62),1))

Again, apologies if this is quite obvious. I have been manually entering the data which I will probably contrinue doing haha. Was just wondering if there is an easier way of doing this?

Any help is greatly appreciated.
Jim

There is no obvious way. Relative references are just that - relative. For example, if you have the formula of =Sum(B2:B5) in cell A1, Excel stores this information as =Sum(The range starting one cell down and one cell to the right from my current location to four cells down and one cell to the right of my current location. Or in R1C1 notation =SUMR[1]C[1]:R[4]C[1])


For the Countif portion of your formula Assuming the first formula is in the second row:

Please Login or Register  to view this content.

Change the "-2" in the ROW()-2 to the row number of your first formula's location.