Countifs with Contains

Michael Foster

Hi All,

Need to add a contains element in to criteria 1 of my countifs formula:

=COUNTIFS({POSG Pack Range 1}, Contains([Primary Column]3,1) {POSG Pack Range 2}, 1)

Can anyone help me progress this?

Many thanks,

Mike

Paul Newcome

=COUNTIFS({POSG Pack Range 1}, CONTAINS([Primary Column]3, @cell))

This is assuming you are searching range 1 for the data that is in [Primary Column]3.

Paul Newcome

=COUNTIFS({POSG Pack Range 1}, CONTAINS([Primary Column]3, @cell))

This is assuming you are searching range 1 for the data that is in [Primary Column]3.

Michael Foster

Hi Paul - Many thanks for your assistance, may i ask a fundamentally stupid question as new to smartsheeet. What is the @cell referencing so i can complete the formula.

thanks,

Mike

Michael Foster

Hi Paul,

This has worked a treat can you please let me know what the @cell is for so i can use it going forward with understanding?

Thanks,

Mike

Paul Newcome

@Michael Foster There are no "stupid" questions. You have to learn somehow right? And what better way than to ask someone who knows?

The @cell reference is actually pretty handy. Basically it tells your formula to evaluate each cell within the range individually. So in the above formula, you first specify your range, then tell the CONTAINS function to evaluate the range on a cell by cell basis for a true/false value, and then the COUNTIFS will tally up all of the trues.

Does that help answer your question?