|Hey there, here is my problem:|
I've defined a name to represent a large number of rows and columns. I'm trying to make a formula that will count the number of instances of a given name in a particular column.
I could just specify the column in the reference but that would require a different name for each column and there are lots. Data is constantly being added so I wanted to be able to have a limited number of names that I could easily change and thus change every formula in one shot.
A X Y
B Y X
C Z Z
I want to count the number of 'Y's in columns 2 and 3 using the name "Current" which represents the first two rows or A1:B2.
It seems like I've tried everything. Is this possible?