Open Office Calc

My220x · 05-03-2008, 06:10 PM

Hello,

I have created a spreadsheet using Open Office Calc. Now I have it so you can select from a drop down list "Yes" or "No" and I wanted to know how I would do it so in a cell I would be able to calculate the number of yeses from certain cells.

Ric_ · 05-03-2008, 08:33 PM

Code:

=COUNTIF(A1:A5;"Yes")

Where A1:A5 is the range.

The Insert Function dialogue is your friend

My220x · 06-03-2008, 05:32 PM

Thanks

My220x · 08-03-2008, 09:19 AM

YAY, managed to do it.

Welcome, Register for free! or Login below:
User Name		Remember Me?
Password

05-03-2008, 06:10 PM	#1
My220x Join Date: Feb 2008 Location: UK Posts: 233 Thanks: 9 Thanked 3 Times in 3 Posts Blog Entries: 8 Rep Power: 2	Open Office Calc - Drop Down Selections Hello, I have created a spreadsheet using Open Office Calc. Now I have it so you can select from a drop down list "Yes" or "No" and I wanted to know how I would do it so in a cell I would be able to calculate the number of yeses from certain cells.

05-03-2008, 08:33 PM	#2
Ric_ Join Date: Jun 2005 Location: Lancashire Posts: 5,578 Thanks: 30 Thanked 151 Times in 132 Posts Rep Power: 44	Code: =COUNTIF(A1:A5;"Yes") Where A1:A5 is the range. The Insert Function dialogue is your friend

08-03-2008, 09:19 AM	#4
My220x Join Date: Feb 2008 Location: UK Posts: 233 Thanks: 9 Thanked 3 Times in 3 Posts Blog Entries: 8 Rep Power: 2	YAY, managed to do it. Last edited by My220x; 08-03-2008 at 10:19 AM..

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Open Office & Word	Domino	Office Software	13	11-02-2008 02:14 PM
Open Office on RM CC3	juno1	Educational Software	2	02-07-2007 07:38 AM
Deploy Open office through GPO to certain PC's	tosca925	Educational Software	4	08-05-2007 08:59 AM
Open Office compatability with MS Office	alan-d	Educational Software	10	04-05-2006 01:50 PM
Open Office	ninjabeaver	Downloads	1	13-06-2005 08:41 AM

		EduGeek.net Forums > Technical > Educational Software
Open Office Calc - Drop Down Selections

06-03-2008, 05:32 PM	#3
My220x Join Date: Feb 2008 Location: UK Posts: 233 Thanks: 9 Thanked 3 Times in 3 Posts Blog Entries: 8 Rep Power: 2	Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search Thread
Show Printable Version Email this Page	Search Thread: Advanced Search

Register now for FREE and post messages!
Username: Password: Confirm Password: E-Mail: Confirm E-Mail: Birthday: Image Verification I agree to forum rules

Educational sofware forum sponsored by