Any OpenOffice gurus? Spread sheet department.
Rod Peterson * Ormond Beach
>I have an Excel spreadsheet in which I've used the formula:
=COUNTIF(B4:B64;"*")-1
to test the cited cells for the presence of text (and subracting 1 because of a header cell within the range). Excel treats "*" as a wildcard for any text, but OO seems to treat it as a literal and not finding any *s in the range returns -1 in the cell with the formula.
I'm only a novice at writing formulas in Excel (or OO), so my original may be suspect. Can anyone help me either write a formula to test for the existence of content or fix mine to work in OO?
Thanks.
Rod



