View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JoeMNY JoeMNY is offline
external usenet poster
 
Posts: 6
Default Non-contiguous named range

I have a range (SOURCE) that consists of non-contiguous cells in a column
(eg. ='Log Sheet'!$O$61:$O$110,'Log Sheet'!$O$125:$O$174,'Log
Sheet'!$O$189:$O$238,'Log Sheet'!$O$253:$O$302,'Log Sheet'!$O$317:$O$366,'Log
Sheet'!$O$381:$O$430). When I use the range in a formula
(=COUNTIF(SOURCE,"<ABCD") it returns the #VALUE error. What am I doing
wrong?

TIA
Joe