[users] Using Countif in Calc

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

Re: [users] Using Countif in Calc

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

Re: [users] Using Countif in Calc

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

Re: [users] Using Countif in Calc

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