Need help with CountIF formula capturing monthly tags
Hi all, I am simply trying to reference each time the business line is mentioned per month. I think I am close? Month number = helper column calculating month. Legacy PCS = the business line I want to count per month. THANK YOU!
=COUNTIFS({Month number}, "1", [{Business line}, "Legacy PCS"])
Answers
-
Hi Nikole,
Give this a shot and let me know if it works for you:
=COUNTIFS({Month number}, 1, {Business line}, "Legacy PCS")
https://www.linkedin.com/in/zchrispalmer/
-
Hi there - I am getting an argument error?
-
The { } brackets from your initial post indicates these columns are being referenced in a separate sheet.
You may have to research the secondary sheet that contains these columns.
Add a test column to the secondary sheet and see if this formula works from there:
=COUNTIFS([Month Number]:[Month Number], 1, [Business Line]:[Business Line], "Legacy PCS")
I was able to replicate the scenario without issues.
See if you can verify these columns in { } brackets are in alignment by clicking
"Reference Another Sheet" from the initial sheet.
https://www.linkedin.com/in/zchrispalmer/
-
hi there sorry it was seemed to not work and then a half dozen tries later we are in business thanks!
-
I'm glad this ended up working for you :-)
https://www.linkedin.com/in/zchrispalmer/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!