| View previous topic :: View next topic |
| Author |
Message |
scrsammy
Newbie
Joined: 26 Apr 2012
Posts: 2
|
 Posted: Thu Apr 26, 2012 7:29 am Post subject: Count function |
 |
|
In D27 I have these values: 4;11;18;25. If I put in D26 '=COUNT(4;11;18;25)', it returns 4, as I'd expect. But if I put '=COUNT(D27)' it returns 0, when I want it to return 4. Can anyone help me?  |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Apr 26, 2012 7:56 am Post subject: |
|
|
One cell can have one value.
"4;11;18;25" is a text value (string of characters with 3 semicolons and 7 digits).
COUNT counts numbers only.
Put the figures in 4 cells, say A1 to A4 and =COUNT(A1:A4) will return 4.
You should read some old Excel book from the flea market.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
scrsammy
Newbie
Joined: 26 Apr 2012
Posts: 2
|
| Posted: Fri Apr 27, 2012 12:09 am Post subject: |
|
|
| Thank you. |
|
| Back to top |
|
|
|
