Count instances in a sheet and plot them against year entered
Hello! Each row in my sheet is a research case. I would like to count each row and plot that number against the year that the case was created. I have a column with the year. How could I do this? I have attached an example of my spreadsheet. In this example I would want a bar graph that says 3 cases for 2020, 6 cases for 2021, and 5 cases for 2022, regardless of if they are completed or not. Thanks!
Answers
-
@jhorvath I am not sure where you want to hold or display the results? I would first build a summary field in that sheet, and then use a Sheet Summary Report to report on the results.
=COUNTIF() is a fairly straight forward formula to use:
=COUNTIFS(year:year, "2020", [case number]:[case number], >0) should count cases in 2020.
dm
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!