Hi. I need an urgent help on my concern. Below is my sample database (because the real one contains around 500 plus area). So I need to count how many specific area was mentioned in the "Area Column" The count shall appear on the "Total Count" column. I want a formula that will reference to "Area Count" to count in the "Area" section. I dont want to use the normal =COUNTIF({Area:Area], "Makati") because I will have to do the formula for a 500 plus area. I dont know if you get me but I hope I can have an answer asap.

Im thinking of something like countif "Area" contains "word in Area Count" but I dont know what Im doing wrong.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!