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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!