How do I get the count of a result from 2 other columns?
I am trying to calculate the count of my Interview Results based on if the 1st attempt was Interview Scheduled and or the 2nd Attempt was Interview Scheduled.
Screen shots provided. Thank you.
This is what I have so far. =COUNTIFS({First Attempt Result}, "Interview Scheduled", {2nd Attempt Result}, "Interview Scheduled") = SUM({Interview Results})
It returns a value of Invalid Column Value.
Answers
-
Assuming the values in the two columns are mutually exclusive (aka cannot have Interview Scheduled for the same row in both columns) the simple formula that can be used is,
=COUNTIF([First Attempt Result]:[2nd Attempt Result], "Interview Scheduled")
-
Thank you for the insight. It does help a little but looking for a different end result.
-
Hi @Cathi R
Can you explain what the end result is that you're looking for? Sameer's formula should work if you want to calculate this within the same sheet. However if you're looking across sheets, I would add two separate COUNTIF statements together, like so:
=COUNTIFS({First Attempt Result}, "Interview Scheduled") + COUNTIFS({2nd Attempt Result}, "Interview Scheduled")
The reason your first formula didn't work is because a COUNTIFS will see the comma between your ranges as an AND, so it would only be counting rows where both sets of criteria were matching (both cells in the same row said "Interview Scheduled").
Let me know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!