Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Is there a way to reference an entire row in a formula? I'm trying to count check boxes across an entire row, but don't want to re-write my formula if I add a column.
Thank you!
I found a way to do it, I just referenced a range of cells in the row. I just have to make sure I insert rows to the right of my last column.
Happy to hear you figured it out! When you select a row range in a formula, inserting a column within that range will include the new column in the formula. But, inserting a column outside of the range will not include the new column in the formula.
