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.
Countifs contains
Trying to count if a cell by criteria if another cell contains "device":
=COUNTIFS(CONTAINS("Device", [eCOA Department]:[eCOA Department]), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]:[Award Date], <=DATE(Year#, 3, 31))
#INVALID OPERATION
Best Answers
-
Try this: =COUNTIFS([eCOA Department]:[eCOA Department], CONTAINS("Device", @cell), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]:[Award Date], <=DATE(Year#, 3, 31)) This assumes Year# being replaced with an actual year.
-
Try the below:
=COUNTIFS([eCOA Department]:[eCOA Department],CONTAINS("Device",@cell), [Award Date]:[Award Date], @cell>=DATE(Year#, 3, 1), [Award Date]:[Award Date], @cell<=DATE(Year#, 3, 31))
Answers
-
Try this: =COUNTIFS([eCOA Department]:[eCOA Department], CONTAINS("Device", @cell), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]:[Award Date], <=DATE(Year#, 3, 31)) This assumes Year# being replaced with an actual year.
-
Try the below:
=COUNTIFS([eCOA Department]:[eCOA Department],CONTAINS("Device",@cell), [Award Date]:[Award Date], @cell>=DATE(Year#, 3, 1), [Award Date]:[Award Date], @cell<=DATE(Year#, 3, 31))
-
That worked thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!