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.4K Ideas & Feature Requests
- 86 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 518 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 that populates the due date based on the date that its approved. I want the date to be at the end of each quarter
- I have a source sheet of different items, rolling out on different dates for different stores. I am creating a target sheet of a rollout of one specific item. I want the target sheet to list all the s…
- = "Not Started" if NO boxes checked = "In Progress" if SOME boxes are checked = "Complete" if ALL boxes are checked for the attached example I manually changed status based on checked boxes, but I'm h…