Count YEAR value?

O

Ole Thomsen

I need to count the number of certain years in a row with date values.

Something like "number of cells in a1..a99 where year=2008"

I tried various ways of using COUNT and YEAR functions, but haven't found
the answer.

Thanks,
Ole Thomsen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Count Values in a Range, Not Formulas 2
Using subtotals in Pivot table formulas 0
YEAR MONTH DAYS COUNTER 2
Complex Count Query 0
Problems with count, counta and countifs 6
Count only cells ending with decimal value of .98 5

Top