Try : =COUNTIF(B1:B3;"1") where "B1:B3" is the answer range.
/paul On 11/3/06, Felipe Monteiro de Carvalho <[EMAIL PROTECTED]> wrote:
Hello, I created a table, with answers from a survey. So I have for example, answers of kind 1, 2 or 3, and my table look like this: First answer 1 Second answer 1 Third answer 3 How can I count the number of answers "1" on that collum? I would like to for example, say that 66% of all answers were of type 1. Using Open Office 2.0 Calc thanks, Felipe --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- Try Torpark; a small portable, open-source, built on Firefox browser that enables anonymous browsing. Requires no installation : http://www.torrify.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
