Countif Reference Equals Name @ Row or CONTAINS


Good morning all. I am trying to create a COUNTIF formula that counts the amount of times a station is listed on the reference sheet if it equals the name at row. I have tried the following two formulas which return 0 when they should be returning the number in the 2022 column:

=COUNTIFS({Station Count}, CONTAINS(Name@row, @cell))

=COUNTIF({Station Count}, Name@row)

I have a list of over 100 names which need to be counted and a formula to change annually would be much appreciated instead of changing every single " ".


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!