Tema: Re: Excelis?
Autorius: LwJ
Data: 2009-01-27 13:28:14
Tai uzsidek, kad nerodytu nuliuku...:)

"Labai Laisvai" <eivitas@nomail.lt> wrote in message 
news:glla0s$go6$1@trimpas.omnitel.net...
>o  jei cia zmogu nervina nuliukai, per visa sheet'a?
> Gal tada geriau Tools-Options_view nuimti varna nuo "zero values"?
> "Juozas V." <vjuozas@istrinti.gmail.com> wrote in message 
> news:g1epn41cak3dvmb8b220ia7dgvvtd40ps4@4ax.com...
>> On Sun, 25 Jan 2009 18:47:38 +0200, "siGis" <s@s.s> wrote:
>>
>>>Kaip ekscelyje padaryti kad sumos celeje nerodytu tol kol bent viename is
>>>dedamuju bus 0.
>> =if(countif(a1:a100;0)=0;sum(a1:a100);"")
>> panasiai taip