5 Replies Latest reply on Oct 2, 2012 7:21 AM by fkoger

    How do I get a count summary of value list items?

    fkoger

      I am trying to set up a layout to count the value list items per month from my records. I can't find the formula to give me the correct results. I have tried ValueCount ( FilterValues (List (Woodruff Instructional Coaching Database::Sep); "X")). My value list includes: X,1,2,3,4,5,6,7,8,9,10. I want to see each month how many of each value list item is selected. I am attaching a screen shot of how I would like the results to display. Any suggestions would be helpful. I am not familiar with custom functions but I am wondering if this would be a better option such as the CountIFs function from Excel. Thanks.