I'm trying to figure out a way to sum the number of one column if it has the value of another column. The formula I was trying is:
I want to know how many are scoped in the scoped column if the channel header is in row 22.
It's reading invalid.
Any other ideas?
Help Article Resources
Check out the Formula Handbook template!