Excel Arrays and Columns

May 3, 2009 at 14:48:59
Specs: Windows 7
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.

For example:

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?


See More: Excel Arrays and Columns

Report •

May 3, 2009 at 15:47:12
I'm a little confused as to how a range of A1:B2 can have a 3rd column.

So, ignoring that, and assuming you really want to reference columns 2 and 3 of a named range, I think this is what you want:


Report •

May 13, 2009 at 00:34:51
Sorry for the confusion. I should have said A1:C2.

In any case, the formula worked beautifully and gave me the hint I needed to properly research the topic instead of blindly searching through formulas.


Report •

Related Solutions

Ask Question