Looks like you missed my response. While you can file an issue if you like, I do not think that it is necessary considering that BASIC does not handle character literals in the way other languages may do.
BASIC needs to employ the CHAR() function for character literals.
However, to enter an Request for Enhancement (RFE) into Issue
Tracker, as this is the best way to have requests such as this
evaluated, use the following:
If you haven't already registered, do the following:
1. To file an issue you must register with OOo by clicking the
My Pages tab and selecting the Register link
http://www.openoffice.org/servlets/Join
2. Fill in your information
3. Reply to the confirmation email that will be sent to the address
you provided.
4. Once you have confirmed, go to www.openoffice.org again
5. And click on the "My Pages" tab from which you can file and find
issues.
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/
--
PLEASE KEEP MESSAGES ON THE LIST.
OpenOffice.org Documentation Co-Lead
http://documentation.openoffice.org/
smime.p7s
Description: S/MIME cryptographic signature
