COUNTIFS issue

cmccarthy

I am pulling data from another sheet in SmartSheets using the COUNTIFS function. I want to count all the times the words "Parish Center" is used in the other page's column. For some reason, however, this function fails to count and it just says zero. I suspect it has something to do with the fact "Parish Center" comes up in the middle of a bunch of other entries in the column such as "Primary School" and "Campus Exterior". How can I ensure the COUNTIFS function will count ALL of the times "Primary School" comes up in the original column?

Nic Larsen

Try using it with a CONTAINS function, similar to this below:

=COUNTIFS(Position:Position, CONTAINS("Parish Center", @cell)

Nic Larsen

Try using it with a CONTAINS function, similar to this below:

=COUNTIFS(Position:Position, CONTAINS("Parish Center", @cell)

cmccarthy

Hello Nic,

Thanks for the help, however, it doesn't seem to work. I tried to pull the data from the same sheet just in case. IN my photos below I am pulling that data from the Buildings column into the helper column, however it comes up as an error.

Error:

Thanks!

Nic Larsen

Looks like you put @row vs @cell. Update your formula and see if that helps.

cmccarthy

Thanks Nic it works! God bless.

cmccarthy

Another question. How would I modify this line so that I pull this data from another sheet? Thanks!

Nic Larsen

When writing the formula on the sheet you want the results, you need to select the link that says Reference Another sheet as shown in this image, look up sheet, and pick the column to count, and then add the criteria just as you did:

cmccarthy

Thanks that works!