My220x Posted March 5, 2008 Posted March 5, 2008 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_ Posted March 5, 2008 Posted March 5, 2008 =COUNTIF(A1:A5;"Yes") Where A1:A5 is the range. The Insert Function dialogue is your friend 1
My220x Posted March 8, 2008 Author Posted March 8, 2008 (edited) YAY, managed to do it. Edited March 8, 2008 by My220x
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now