Count if rows contains specific year
Closed
Luke
-
Jul 3, 2015 at 05:42 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 3, 2015 at 08:32 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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
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
Related:
- Count if rows contains specific year
- How to find specific words on a page - Guide
- How to count names in excel - Guide
- How do i find a specific video on youtube - Guide
- Excel count occurrences - Guide
- How to delete rows and columns in word - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 3, 2015 at 08:32 AM
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
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
