OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

COUNTIF error

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
WaltP
Guest





PostPosted: Mon May 24, 2004 7:31 pm    Post subject: COUNTIF error Reply with quote

I'm trying to count the number of 'Y's in a column and keep getting an error. I've tried every syntax I can think of from

=COUNTIF(p4:p100, Y)
to
=COUNTIF(p4:p100, "=Y")
single quotes, double quotes, no quotes.... and all I get as a result is #NAME?

The cells in question have either Y, N, space, or empty

Any ideas? Using OO 1.1.1

Thanks,
Walt
Back to top
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Mon May 24, 2004 8:53 pm    Post subject: Reply with quote

Try looking at the syntax for formulas in CALC ... the separator between arguments is a semicolon not a comma.

=COUNTIF(p4:p100;"Y")

Another helpful feature in CALC is the autopilot for functions which completes the syntax for you and provides a link to the HELP. Do Insert > Function....
Back to top
View user's profile Send private message
geoff_f
OOo Enthusiast
OOo Enthusiast


Joined: 21 Nov 2003
Posts: 181
Location: Canberra, Australia

PostPosted: Tue May 25, 2004 3:23 am    Post subject: Reply with quote

dfrench said:
Quote:
Another helpful feature in CALC is the autopilot for functions which completes the syntax for you and provides a link to the HELP. Do Insert > Function....

Also get this autopilot by clicking on the AutoPilot: Functions button - the left most button on the Formula Bar. This should be used for everything, except maybe the most simple of formulas. IMHO, this dialog is a marvellous example of effective user interface, making complex nested functions child's play - much easier to use than the competition's.
Back to top
View user's profile Send private message
Guest






PostPosted: Tue May 25, 2004 9:15 pm    Post subject: Reply with quote

Ahhh, thank you. I wish the help files mentioned ; instead of ,
Oh well.
Back to top
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Wed May 26, 2004 12:30 am    Post subject: Reply with quote

Perhaps I should not rub it in but the syntax for every function is documented in the HELP

Quote:
Syntax:
COUNTIF(range; criteria)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group