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!

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!

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
---

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!