| View previous topic :: View next topic |
| Author |
Message |
WaltP
Guest
|
 Posted: Mon May 24, 2004 7:31 pm Post subject: COUNTIF error |
 |
|
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
Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand
|
| Posted: Mon May 24, 2004 8:53 pm Post subject: |
|
|
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 |
|
|
geoff_f
OOo Enthusiast
Joined: 21 Nov 2003
Posts: 181
Location: Canberra, Australia
|
| Posted: Tue May 25, 2004 3:23 am Post subject: |
|
|
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 |
|
|
Guest
|
| Posted: Tue May 25, 2004 9:15 pm Post subject: |
|
|
Ahhh, thank you. I wish the help files mentioned ; instead of ,
Oh well. |
|
| Back to top |
|
|
dfrench
Moderator
Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand
|
| Posted: Wed May 26, 2004 12:30 am Post subject: |
|
|
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 |
|
|
|
