Count/Countif/Countifs - contents contain xxx
Hi there, I am trying to create a count/countif/countifs formula where only part of the data is in the column I want to include. Can you please help with this.
For example if the cell data states F24 today budget planning and another cell says F24 tomorrow budget planning.
I need to create a formula that says if it contains "F24 today" then count it. Meaning contains F24 today
Thank you
Answers
-
You would use something along the lines of
=COUNTIFS([Column Name]:[Column Name], CONTAINS("F24 today", @cell))
-
Thanks, I'll try that now.
-
I am trying this but it isn't working. Just comes back #UNPARSEABLE
=COUNTIFS({Description}:{Description}, CONTAINS("F26 Tap", @cell))
The Description = a link to another reference sheet and a reference to a column of data x 2
but for the @cell, I have just written in that text. Does that have to be a reference or pointer or something like that?
-
Here is more information on referencing another sheet with cross sheet references:
And here is some more information on @cell:
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!