COUNTIF Column Totals - Would like to Exclude Two Cells
We have a form connected to our sheet. Form submissions are added to the top. Each column asks a question where the submitter can choose one of three answers: Yes, No, or Don’t Know
The Yes, No, Don’t Know totals are at the bottom of the sheet using the COUNTIF formula. We originally set up the formula to include the rows currently on the sheet — not realizing that it wouldn’t include the added rows. We’d like to be able to view live totals as new submissions are added above.
So, we tried to use the COUNTIF formula for the column (to include the added rows). It worked fine for the first set of totals (Yes) until we tried to add the COUNTIF formula for the column on the second set of totals (No) and the third set (Don’t Know.) It appears the cell formulas interfere with each other, and we get #BLOCKED, #UNPARSEABLE, and #CIRCULAR REFER errors. How do we EXCLUDE those other two cells from each column total?
See Screenshots. Note: The totals don’t match the screenshot because I didn’t include all the rows in the picture.
Answers
-
You would need to move the additional counts to a different column or a different sheet.
-
Thank you. I wish I could find a work-around. Visually, the data is so much easier to interpret with the answers tallied at the bottom of each column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!