From X to End of column
My sheets have a "header" that serves as a navigation and also serves for the metrics. My problem is that I would like to have the range of a function encompass the entire column (open-end) but i want to be excluding the aforementioned header rows.
I tried thing such as [Column Name]21:[Column Name] in an attempt to splice the two options of range together. The option of working with the CHILDREN function doesn't work either since I am trying to count the contents of parent, children and grandchildren.
If anybody has an idea i haven't tried yet i would be very interested in hearing it.
Thanks a lot in advance!
Help Article Resources
Check out the Formula Handbook template!