Finding the total number of instances per year
try using Countif for both of yours requirement, something along this
=COUNTIF(A:A,"1975")
Does this do what you want ? of not, pls post back with samples
HTH
--
Appreciate you click on the Yes button below if this posting was helpful :)
Thank You
cheers, francis
"Rob" wrote:
it doesn't seem like it should be all that difficult. I have a column with
several (650+) dates going back to 1975. I'd now like a table that tells me
how many entries I have per year. How would I go about doing that?
Similarly, I have category columns where a particular instance fit into that
category, I entered an "X". How would I now go about figuring out how many
of each category occured each year?
Thank you in advance. You are all lifesavers!
|