0
I have a spreadsheet that has a column of dates in it. I want to be able to count how many cases are 2013, 2014 etc.
If they were just years, it would be easy but they are dates, hundreds of dates from 2013 - 2016. So I need a way of counting how many occurrences of each year are in the column.
I've tried countif, sumif and frequency, but none give the correct answer.
Angie Lambert
Posted 2016-09-19T09:48:39.553
Reputation: 1
Your answer is technically correct, but locating the 2013 result next to a 2016 date is confusing until the reader realizes it's a random location. Might be clearer to use column C for a list of years, and then use a cell reference to the year in your formula in col D. – fixer1234 – 2016-09-19T19:00:34.877
I managed to use this formula =COUNTIF(O:O,">1/1/2015") but then when I wanted to count up only the 2014 it also count the 2015, so I ended up putting -D5 at the end to get the correct figure. When I got to adding up 2012 I had -d5-f5-h5 at the end of my original formula. Is there an easier way? – Angie Lambert – 2016-10-05T11:29:48.533