Count instances in a sheet and plot them against year entered

jhorvath

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!

example.JPG

Dale Murphy

@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