Countifs with Row Reference
Hello
I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the other sheet and allow me to copy the formula down.
My formula is fairly simple =COUNTIF({KPI DATA File Range 1}, "Pass") and the "Pass" changes for the other 3 columns. I just cannot seem to remember how to add the row reference.
Can anyone help?
Answers
-
When you say "row reference" are you referring to a unique row value so it knows which row to perform the countif formula on?
If so you would need a unique identifier on each row to use as a row reference.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!