COUNTIF and Named Ranges -- Please Help!

[darknesseofmagyk]

Good afternoon, friends!

I'm in pretty bad need of help right now. I've defined a range that consists of a certain number of rows and all columns in the spreadsheet. Let's call this range initial ($2:$730).

What I'd like to do is use a COUNTIF function to check cells in column DX (column 128) with "never". Without a named range I would use:

=countif(dx2:dx730,"never")

Unfortunately, I'm dealing with 300+ columns and a number of specific named ranges.

I've tried =countif(initial,,128,"never") to no avail. Can someone please help me?

 

[Jonmo1]

Welcome to the board..

Index is usefull here..
=INDEX(initial,0,128)

That would return a range equivelent to DX2:DX730

So to put that in the countif
=COUNTIF(INDEX(initial,0,128),"never")


Hope that helps.

 

[darknesseofmagyk]

Jonmo, you. are. my. hero.

Thank you so much! It works perfectly. I obviously have much to learn--I'd never even used the Index function before!

Again, thank you. Happy Thursday!

 

[Jonmo1]

Glad to help, thanks for the feedback..

Index is one of the most powerfull functions in Excel....You should get to know it..