Ryno --
There is no need, GRS posted a solution.
Instead of just using <>G use <>char(G)
HTH,
Peter
Ryno Labuschagne (ISS Namibia) wrote:
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: [email protected]
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: [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]
---------------------------------------------------------------------
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]
