Unparseable Message on Column Formula

ReNae Smith

I can't get this formula to work in my spreadsheet, any suggestions on how to fix it?

=countif([Column5]@row11:[Column16]@row11, "*"&[Column17]$10&"*")

Paul Newcome

It looks like you are trying to count how many cells between [Column5] and [Column16] (on each row) contains the value in [Column17]$10. Is that correct?

Paul Newcome

It looks like you are trying to count how many cells between [Column5] and [Column16] (on each row) contains the value in [Column17]$10. Is that correct?

ReNae Smith

Yes!

Paul Newcome

Formula syntax between Excel and Smartsheet isn't always compatible. Give this a try:

=COUNTIFS([Column5]@row:[Column16]@row, CONTAINS([Column17]$10, @cell))

ReNae Smith

That worked!! Thank you!!

Paul Newcome

Happy to help. 👍️