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 Cohen
http://what-is-what.com
http://gibberish.co.il
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
2009/12/17 Dotan Cohen dotanco...@gmail.com:
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)
I think you put the quotes at the wrong place.
=SUMIF(F2:F1388; value; G2:G1388)