Count if rows contains specific year
Closed
Luke
-
3 Jul 2015 à 05:42
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 3 Jul 2015 à 08:32
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 3 Jul 2015 à 08:32
Related:
- Count if rows contains specific year
- How do i find a specific video on youtube - Guide
- Excel count occurrences - Guide
- How to hide subscriber count - Guide
- Count names in excel - Guide
- How to search for a specific word on a webpage - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
3 Jul 2015 à 08:32
3 Jul 2015 à 08:32
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
