Weird Error in Excel Formula - Correct syntax is use!

[c-f]

Tell me what I'm doiing wrong here! I'm using the COUNTIF formula

=COUNTIF(A1:A36, 1)

Everytime excel return me an error saying : "the formula that you
typed contains error" And it highlight A36 in the formula...

The Syntax is EXACTLY the same as the one in Excel Help!

HELP ME!

P.S I'm using office X for Mac

Thanks

C-F

 

[Harlan Grove]

I don't speak mac but it should be OK. Try leaving the workbook and coming
back and/or leaving excel and coming back. Or, re-boot....

...

Rebooting doesn't matter with *stable* operating systems.

 

[Harlan Grove]

Tell me what I'm doiing wrong here! I'm using the COUNTIF formula

=COUNTIF(A1:A36, 1)

Everytime excel return me an error saying : "the formula that you
typed contains error" And it highlight A36 in the formula...

First, delete the space after the comma. If that doesn't work, replace the comma
by a semicolon.

 

[Don Guillett]

=COUNTIF(A1:A15, 1) worked just fine

...

First, delete the space after the comma. If that doesn't work, replace the comma
by a semicolon.

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.

 

[Harlan Grove]

And what, prey tell, is a *stable* operating system?

Anything that doesn't start with 'W'.

 

[Harlan Grove]

=COUNTIF(A1:A15, 1) worked just fine

Yes, it will if they're ASCII spaces (32 decimal), but it'll fubar as a syntax
error if they're nonbreaking spaces (160 decimal). Expedient to delete them
rather than to screw around figuring out which kind they are.

 

[Rick C]

1. Into which cell are you typing the formula? It wouldn't be A36 would it?
2. Does the same problem happen in every cell? What if your reference is
just A1:A2?
3. Is that definitely a comma after A36, or might it be some other
character?

 

[J.E. McGimpsey]

And what, prey tell, is a *stable* operating system?

Well, an OS that doesn't crash, for one. My Mac OSX hasn't crashed
since December '01, and that was due to my tweaking the window
manager daemon. It has been rebooted, perhaps once per month or so,
for system updates/power outages, etc., during that period. Between
Beta tests, my own development and the occasional buggy software, I
have apps that crash every day without taking down the OS.

My dual Linux/Windows box hasn't crashed in over 2 years, but that's
been run almost exclusively as a Linux server with only a couple of
apps doing some long-term failure tests, so it hasn't really been
challenged.

I realize that's not the only measure, of course.

I hear Windows XP does pretty well, too, but I don't run it very
often.

 

[Ken Wright]

Win 98 used to crash occasionally on me. Win ME started out OK, but over time got to the point
where it would blue screen literally 2 to 3 times day. Since going to XP months ago now, I have
not had it crash once that I can remember. Much much better than it's predecessors (In that
respect anyway).

 

[Anders S]

C-F,

What if you do Insert->Function..., choose COUNTIF() and select A1:A36 with the
mouse? Just to eliminate typos.

Regards
Anders Silven

 

[Myrna Larson]

Win XP Pro has crashed only once for me since October, 2002, and that was due to a corrupted
Publisher document.

 

[Tom Ogilvy]

So he might have accidently entered a nonbreaking space while typing in his
formula?. Anyway, in windows, it gives you a "your formula contains an
error" and highlights the nonbreaking spaces and the 1. So doubtful if that
is the problem.

 

[Tom Ogilvy]

So does the formula not work on your MAC?

 

[J.E. McGimpsey]

It works just fine - can't imagine why the OP's having trouble.