Hi Christian,
Separating the answer into columns can be done quite easily using the
text to columns macro. Once done, the coutif can accept a range covering
all the columns. If the data are already in multiple columns, it gets
harder.
tc
Naomi Kramer wrote:
Apologies. I just read your email properly. Please ignore previous
reply.
- Naomi
So you want a count of all non-blank cells?
If so, try this:
=counta(a1:b90)
(obviously you'll need to put your own cell range in)
- Naomi
Hi,
I am using OO 1.9.79 Beta and am trying to use the
Countif function to analyze data from a survey.
There are some questions that have more than one
possible answer. I would like to be able to count any
occurrence of a number in a cell (separated by
commas), even if there is more than one number in each
cell.
Is there a way to do this? Or should I use Base and
use a query? Do I have to resort to separating each
response into one column (hope not)?
Any reply would be appreciated,
Christian
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
