Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding last column in non-contiguous range | Excel Worksheet Functions | |||
DSUM - non contiguous criteria range | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Excel copy formulas using non contiguous range | Excel Discussion (Misc queries) | |||
SUMIF non-contiguous range | Excel Worksheet Functions |