Subject: Re: Countif
I have tried =SUMIF(John_Lynch,"+") this gives
a #value error,
"+" refers to a text symbol that has to be added
to a number.
> Just put the name of the Named Range as the first
parameter.- you
> don't need quote symbols around the name.
>
>
> At 09:00 1-03-2006, you wrote:
>
>>Hi All
>>
>>Using Countif(range,"+"),
>>Is there any way to use a Named Range as the range
??
>>
>>Derek McGIll
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|