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) where ”value” is a value, for example: =SUMIF(F2:F1388; "<>3"; G2:G1388) or =SUMIF(F2:F1388; "<>" & A1; G2:G1388) The last one concatenates ”<>” with whatever is in A1. I think A1 needs to be a number, though. Johnny Rosenberg > > Thanks in advance. > > -- > Dotan Cohen > > http://what-is-what.com > http://gibberish.co.il > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org