Previous Topic Next Topic

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
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 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses