Countif year = help needed

[saffron]

Hello, I am new to this forum and appreciate any assistance. I hav
looked for answers to my problem but am not finding anything. What
want to do seems simple but I can't seem to figure it out and wil
probably kick myself once I get the assistance. I have a simpl
spreadsheet to track install dates. All I want is to count how man
times each year is represented. The column is in date format 1/1/200
the range is G1:G175. The actual dates vary through the current year
Thank you in advance

 

[plinius]

Il 11/09/2012 23:02, saffron ha scritto:

Hello, I am new to this forum and appreciate any assistance. I have
looked for answers to my problem but am not finding anything. What I
want to do seems simple but I can't seem to figure it out and will
probably kick myself once I get the assistance. I have a simple
spreadsheet to track install dates. All I want is to count how many
times each year is represented. The column is in date format 1/1/2005
the range is G1:G175. The actual dates vary through the current year.
Thank you in advance!

Put in H1 year to be tested

In I1:
=SUMPRODUCT(1*(YEAR($G$1:$G$175)=H1))

Hi,
E.

 

[saffron]

Thank you Spencer101,

This worked for me, I really appreciate the assistance!!

Hi,

Have a look at the attached.

I've included a worksheet with an example for Excel 2003 and one fo
later versions as they use different formulas, although the 2003 versio
will work in later versions also.

I've added date cells to give a start date (and end date in the case o
2003).
You could hardcode the dates into the formula, but if you ever need t
change the year and recalculate it's easier to change one cell than i
is to change formulas.

Hope that's of help.
Let me know if I've misunderstood your requirement.

S

+-------------------------------------------------------------------
+-------------------------------------------------------------------