[users] NotEqual for SUMIF? does not work

2009-12-17 Thread Dotan Cohen
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

Re: [users] NotEqual for SUMIF? does not work

2009-12-17 Thread Pradeep Srinivas
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

Re: [users] NotEqual for SUMIF? does not work

2009-12-17 Thread Johnny Rosenberg
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)