Peter Kupfer The <> means not equal to in Excel. I opened a spreadsheet made in Excel with this formula using <> and I saw that it was not working properly. And I started playing, your answers I tried already, it works, but I need a way to say not equal to "X". Another question; In the same situation, how would you tel the formula to add all those where the cell is empty?
Thanx Ryno Labuschagne -----Original Message----- From: Peter Kupfer [mailto:[EMAIL PROTECTED] Sent: 27 June 2006 00:58 To: [email protected] Subject: Re: [users] OOo Calc SUMIF problem Ryno -- Two problems: 1) The ranges, when I opened it were wrong, but that is probably trivial. 2) As per the help file (I just pushed the help button in the formula wizard dialog) the enter criteria needs to be in quotes. I am not sure what <> means, but if you are trying to say if that criteria equal G then you would put: =SUMIF(G7:G17;"=G";F7:F17) Or, just modifying yours, (which gave me 0) =SUMIF(G7:G17;"<>G";F7:F17) HTH, and remember that the in product help is usually pretty helpful. Peter Ryno Labuschagne (ISS Namibia) wrote: > Hi, > > Please see attached calc sheet with formula and error. > Can somebody please help me? > > Thanx > > Ryno Labuschagne > > > ---------------------------------------------------------------------- > -- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] For > additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
