Countifs - Referencing another sheet with multiple criteria
Hi! On my metrics sheet I am trying to count if Status (different spreadsheet) is "requested received" and the request type = 1) Surveys - Custom Cut, 2) Surveys - New Custom Survey or 3) Surveys - Analysis/Investigation. I keep getting....any idea what I am missing?
Thanks in advance!
Answers
-
Hi @AGK, it would be better if you include some more details, such as formula you are trying to fix and aleso mentioned what do you keep getting (error? what error?...) Anyway, from as little information as you mentioned the formula should look something like:
=COUNTIFS({Status}, "requested received", {Request Type}, OR(@cell = 1, @cell =2, @cell = 3))
'@cell = 1, @cell =2, @cell = 3' could possible also be '@cell >= 1, @cell <= 3'
Hope it makes sense?
Regards
Vojtech
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!