On Tue, 2006-06-27 at 16:38 -0500, Peter Kupfer wrote: > 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 >
Peter nad Ryno,
Try =SUMIF(B1:B9;"<>CHAR(G)";A1:A9) as the incantation. With a table
like this:
1
2
G
3
4
5
G
6
7
8
> 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: [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]
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
PLEASE KEEP MESSAGES ON THE LIST.
OpenOffice.org Documentation Co-Lead
http://documentation.openoffice.org/
smime.p7s
Description: S/MIME cryptographic signature
