On Thursday 17 December 2009 18:30:49 Dotan Cohen wrote:
> I need to test if the content of a cell is _not_ a certain
> alphanumerical value. How can I do this? The below code does not
> work: =SUMIF(F2:F1388; <>"value"; G2:G1388)
>
> Thanks in advance.
>
Dotan,
Would this help :
{=sum(if(F2:F1388 <> "Value";G2:G1388;0))}
The "{" and "}" are not typed in - they are inserted automatically by
Calc when you press a "Shift Control Enter". What this does is checks
if the Array F2:F1388 does not contains "Value". If true (i.e., it
does not contain Value) then, it supplies the corresponding cell from
the array G2:G1388 to the sum() function. Otherwise, it supplies the
value of Zero to the sum() function.
Perhaps you may want to look for "Array Functions" in the Calc help
section ?
--
Pradeep Srinivas
on 17 Dec 2009, Thursday, IST (which is GMT +05:30)
-----------------------------------------------------------------------
Every path hath a puddle.
-- George Herbert
-----------------------------------------------------------------------
Signature block is /auto/ /generated/ from the Unix utility *fortune*
fortune run at 20:20 IST on 17 Dec 2009, Thursday
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
