can't use function 'countif' in named range
 

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 ?

can't use function 'countif' in named range
 

Hi,

It works absolutely fine for me. I used the following formula
=COUNTIF(name,"A"). Name is defined as the range =Sheet1!$A$1:$A$7

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Roland" wrote in message
...
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 ?

can't use function 'countif' in named range
 

not if Name is defined as ='Sheet1'!$W$189:$W$196,'Sheet1'!$W$200:$W$205

"Ashish Mathur" wrote:

Hi,

It works absolutely fine for me. I used the following formula
=COUNTIF(name,"A"). Name is defined as the range =Sheet1!$A$1:$A$7

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Roland" wrote in message
...
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 ?

can't use function 'countif' in named range
 

Hi,

You can use 2 countif() functions instead. You ofcourse will have to define
the ranges differently

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Roland" wrote in message
...
not if Name is defined as ='Sheet1'!$W$189:$W$196,'Sheet1'!$W$200:$W$205

"Ashish Mathur" wrote:

Hi,

It works absolutely fine for me. I used the following formula
=COUNTIF(name,"A"). Name is defined as the range =Sheet1!$A$1:$A$7

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Roland" wrote in message
...
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 ?