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
Check out the Formula Handbook template!