Count/Countif/Countifs - contents contain xxx

Paula Shaver

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

Paul Newcome

You would use something along the lines of

=COUNTIFS([Column Name]:[Column Name], CONTAINS("F24 today", @cell))

Paula Shaver

Thanks, I'll try that now.

Paula Shaver

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?

Paul Newcome

Here is more information on referencing another sheet with cross sheet references:

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

And here is some more information on @cell:

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell