I have a volunteer submission form which has about 10 columns that exist as just checkboxes on/off - each of these relate to a conference work area and volunteers often select multiple.

To easily view the data for a single person/row without tons of scrolling and looking up and down at column


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


I've sent a series of Update Requests to external emails and I've had about 50% response rate.  I have had someone check the validity of the remaining email addresses and we've found several of the email addresses are no longer valid (they don't exist) and several others are issuing Out of Office