Finding the total number of instances per year
 

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!

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!

Finding the total number of instances per year
 

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.

Try a pivot approach. Fast n easy.

Assuming real dates running in A2 down, with col header: Date in A1.
Select say, A2, then click Data Pivot table. Click Next Next. In step 3
of the wiz., click Layout, then drag n drop "Date" into both ROW and DATA
areas. Click OK Finish. Hop over to the pivot sheet. Right-click on "Date"
Group & Show Detail Group. In the Grouping dialog, select Years OK, to
get the required results.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

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!