Peter, I'm new to the user group, how can I report it as an issue?
Ryno Labuschagne -----Original Message----- From: Peter Kupfer [mailto:[EMAIL PROTECTED] Sent: 27 June 2006 22:38 To: users@openoffice.org Subject: Re: [users] OOo Calc SUMIF problem Ryno -- So I tried a few things and this is interesting. According to <> the <> operator is not equal to (I didn't know that). I applied that a spreadsheet like yours it looked roughly like this A B - - 1|1 2|2 3|3 G 4|4 5|5 G I used an equation like =SUMIF(B1:B5;"<>G";A1:A5) in cell A6. In the above spreadsheet I received a value of 0 in A6. However, if I put any value in B1, I got a value of 1 in cell A6. So, the issue is, that it considers cells B1,2, & 5 to be empty but it doesn't evaluate them as anything! Weird. So, that is the problem. I don't know how to fix that. I tried formatted the cells as different things with no success, so I will leave that for you to fix or report as an issue. HTH, Peter Ryno Labuschagne (ISS Namibia) wrote: > 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: users@openoffice.org > 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] > --------------------------------------------------------------------- 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]