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
Related:
- Count if rows contains specific year
- How to find specific words on a page - Guide
- How to count names in excel - Guide
- If cell contains multiple specific text ✓ - Excel Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
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