Welcome, Guest
Username: Password: Remember me

TOPIC: Extending the countif() function

Extending the countif() function 1 year 7 months ago #92744

  • LSCitizen
  • LSCitizen's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 38
  • Karma: 0
Hello -
I need some help. I have a series of questions(this series of questions repeats 5 times):

Q1. How old are you? (numerical input)
Q2. Would you like to participate in our survey? (IF Q1 greater than 18; yes/no question)
Q3. Why not? (If Q2 = no)
Q4. Thanks for your time (If Q1 less than 18).

I want to be able to count the number of Q1 values that are greater than 18. Is there a way to extend the countif() function to do this? Or this another way to do this?
The administrator has disabled public write access.

Extending the countif() function 1 year 7 months ago #92745

  • TMSWhite
  • TMSWhite's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 759
  • Thank you received: 82
  • Karma: 36
Use the countifop() function. For example, say your Q1-like questions are Q1, Q11, Q21, Q31, ...
countifop(">",18,Q1,Q11,Q21,Q32)
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.153 seconds
Donation Image