Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Formula to describe # of applicants per department in a specific quarter.
I have a CountIFs formula I have been trying to make work in order to tell me how many applicants we have for a specific department within a quarter.
=COUNTIFS({Quarter}, "Q1 2025", [{Department,[Primary Column]@row])
I am receiving an UNPARSEABLE error. Both range1 and range2 are references to the same separate sheet, but different columns. Both columns are drop down selections. The primary column is the department name.
Any help would be so appreciated!!!! Thanks!
Answers
-
The square brackets around the second range/criteria set need to be removed. You are also missing a closing curly bracket after the second {Cross Sheet Reference}.
-
I fixed this, but now I am getting an Invalid reference error. Any Ideas?
-
That means at least one {Cross Sheet Reference} has not been properly created.
.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.4K Get Help
- 465 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.5K Ideas & Feature Requests
- 86 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I need a formula for if a value in Column A Sheet A matches a value in Column B Sheet B, return date from Column C Sheet B. I have been playing around with vlookup, match, and if statements and am hav…
- This discussion was created from comments split from: CountIF with multiple values in the same cell (same sheet).
- I ran into an odd situation where the formula I am using is not working in some cells. I tried using this as a column formula (How I would prefer). I also tried it as a cell formula. But I have random…