Help with formula
I am setting up as simple tracking of an annual communications plan and have a Platform of Engagement column with about 12 drop down platforms to select from. I want a formula to track the amount of engagement on each platform selected within this column. The following formula works counting for one platform of engagement, selection was Community Partnership:
=COUNTIF([Platform of Engagement]:[Platform of Engagement], "Community Partnership")
But when I try this same formula in another cell with "Website" for example, I get circular reference and blocked. But I can't work out why? I can't work out where the circular reference is? Or why this
Help Article Resources
Check out the Formula Handbook template!