What I am trying to ask, is, why are cells B1:B5 a named range? why are cells
B8:B10 a named range, and B15+ a named range? What makes them named? What
criteria are you using to name these ranges?
--
** John C **

"rolando" wrote:

no regularity in ranges. ranges will be decrease or increase on regular base.
ranges are defined in 1 single column
for example; range name is defined as cells B1:B5 + B8:B10 + B15
only last cell, B15, can be extended or new ranges can follow further down
regards
roland
"John C" wrote:

There might be other methods of doing your counts. Are your named ranges
broken up with regularity? What defines a named range? Is it a particular
column, cell, calculation?
--
** John C **


"Roland" wrote:

agree
but the named range is dynamically, meaning it expands on regular base, this
mean I have to change the formula each time !

"Gary''s Student" wrote:

You can't use COUNTIF() in disjoint ranges. Use:

=COUNTIF()+COUNTIF()+...

instead
--
Gary''s Student - gsnu200811


"Roland" wrote:

have a named range from non-adjacent ranges
most of Excels build-in functions can be used with this named range (such
as, min, max are sum)
However the function CountIf can't be used,
got a message in the cell "#value!"
why is that ?