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.