Count if rows contains specific year

Closed
Luke - Jul 3, 2015 at 05:42 AM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Jul 3, 2015 at 08:32 AM
Hello,
I need to count how many rows contains a date with a specific year, but with the following doesn't work:
=COUNT.IF(D3:D3394;"*2014")
I changed also the format of the date into day month year, and tried with different formulas, but nothing, it's not coming out correct.

Thanks,in advance,
Luke

1 reply

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Jul 3, 2015 at 08:32 AM
Luke, Good morning.

Try to use:
=SUMPRODUCT((YEAR(D3:D3394)=2014)*1)

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0