+ Post New Thread
Results 1 to 4 of 4
Educational Software Thread, Open Office Calc - Drop Down Selections in Technical; Hello, I have created a spreadsheet using Open Office Calc. Now I have it so you can select from a ...
  1. #1
    My220x's Avatar
    Join Date
    Feb 2008
    Location
    UK
    Posts
    257
    Thank Post
    9
    Thanked 3 Times in 3 Posts
    Blog Entries
    8
    Rep Power
    14

    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.

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,596
    Thank Post
    109
    Thanked 764 Times in 595 Posts
    Rep Power
    181
    Code:
    =COUNTIF(A1:A5;"Yes")
    Where A1:A5 is the range.

    The Insert Function dialogue is your friend

  3. Thanks to Ric_ from:

    My220x (6th March 2008)

  4. #3
    My220x's Avatar
    Join Date
    Feb 2008
    Location
    UK
    Posts
    257
    Thank Post
    9
    Thanked 3 Times in 3 Posts
    Blog Entries
    8
    Rep Power
    14
    Thanks

  5. #4
    My220x's Avatar
    Join Date
    Feb 2008
    Location
    UK
    Posts
    257
    Thank Post
    9
    Thanked 3 Times in 3 Posts
    Blog Entries
    8
    Rep Power
    14
    YAY, managed to do it.
    Last edited by My220x; 8th March 2008 at 09:19 AM.

SHARE:
+ Post New Thread

Similar Threads

  1. Open Office & Word
    By Domino in forum Office Software
    Replies: 13
    Last Post: 11th February 2008, 01:14 PM
  2. Open Office on RM CC3
    By juno1 in forum Educational Software
    Replies: 2
    Last Post: 2nd July 2007, 07:38 AM
  3. Deploy Open office through GPO to certain PC's
    By tosca925 in forum Educational Software
    Replies: 4
    Last Post: 8th May 2007, 08:59 AM
  4. Open Office compatability with MS Office
    By alan-d in forum Educational Software
    Replies: 10
    Last Post: 4th May 2006, 01:50 PM
  5. Open Office
    By ninjabeaver in forum Downloads
    Replies: 1
    Last Post: 13th June 2005, 08:41 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •