Formula Issue
Hello!
I am trying to reference another sheet column to show how many tours were in 2023. I cannot figure out where I messed up in the formula. Any help would be greatly appreciated! Current formula I am trying: =COUNTIFS({Stanford Hospital Tour Request Range 7})([Tour Date]:[Tour Date], IFERROR(YEAR(@cell), 0) = 2023)
Answers
-
When you create a {Cross sheet reference}, you should be selecting the specific range you want. If you want an entire column, you would click the column header. This means you should not have an additional Column:Column range.
=COUNTIFS({Stanford Hospital Tour Request Range 7}
)([Tour Date]:[Tour Date], IFERROR(YEAR(@cell), 0) = 2023)=COUNTIFS({Stanford Hospital Tour Request Range 7}, IFERROR(YEAR(@cell), 0) = 2023)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!