Can a range be specified with a beginning and no end?

Jacob Slaathaug
edited 12/09/19 in Smartsheet Basics

I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors.  Is there a way to specify a range from row 25 to infinity?  I'd like additional rows to automatically be included in my summary calculations.

The formulas I'm using are similar to what is shown below.

=COUNTIFS([Cond. Removed]:[Cond. Removed], =1, Parent:Parent, ="Retirement", [Pole Top Assembly]:[Pole Top Assembly], NOT(ISBLANK(@cell)))