rjplante
Well-known Member
- Joined
- Oct 31, 2008
- Messages
- 569
- Office Version
- 365
- Platform
- Windows
I have two columns, ColA with a date in it and the ColB with just the years from 2006 - 2017. I would like a formula which counts the numbers of rows in ColA that have years that match the year listed in ColB. I am currently using the formula listed below and it is not working. Please help. I know this is simple, just having a brain derailment on this one.
=COUNTIF(A:A,YEAR(B2))
Thanks in advance,
Robert
=COUNTIF(A:A,YEAR(B2))
Thanks in advance,
Robert