Finding the total number of instances per year
Hi,
Two solutions come to mind:
1. Use a pivot table
2. Use a formula like
=SUMPRODUCT(--(YEAR(A1:A650)=1975)
or
=SUMPRODUCT(--(YEAR(A1:A650)=B1)
where B1 contains 1975
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Rob" wrote in message
...
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!
|