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?