COUNTIF also works fine in OpenOffice.org; it's probably one of the most
commonly used cell formulas, so if it didn't work, many people would be very
loud about it and the bug would be corrected rather quickly.
I guess it's very hard to tell what's wrong in your case without having a
look at the file. If you can't attach it here, upload it somewhere and give
us the link so we can have a look at it.
What do you mean by "crashed"? It seems like peole say "crash" about just
about anything these days. To me a crash means that the program shuts down,
with or without an error message. I guess that sometimes I say "crash" when
I mean "freeze" too.
J.R.
2007/8/25, Harold Fuchs <[EMAIL PROTECTED]>:
>
> On 25/08/07, Steve Domina <[EMAIL PROTECTED]> wrote:
> >
> > Question:
> >
> > I have a Excel file that I tried to open in OOoCalc/Math (spreadsheet).
> > It has two conditional formulas in it.
> > First time I tried to open it in Ooo, it crashed: hmmm...it also crashed
> > the
> > 2nd time.
> > I commented those two formulas out, and tried to open it.
> > After forever, it opened it up.
> > However, when I tried to get there two Conditional formulas to work,
> they
> > don't.
> > (it was COUNTIF) Works fine in Excel.
> > Dell Inspiron 1501, 1GB Ram, 80GB+ HD.
>
>
> I don't know the syntax for COUNTIF in Excel . Check in Calc's Help for
> the
> OpenOffice syntax for COUNTIF. I have a strong feeling it'll be different.
> For example, Calc wants semicolons (";") between the arguments of a
> formula.
>
> But then I've been wrong before ;-)
>
> Just out of interest, how did you "comment out" the formulae without being
> able to open the spreadsheet?
>
>
>
> --
> Harold Fuchs
> London, England
> Please reply *only* to users@openoffice.org
>
