Countif

[penumbra547]

Hi All,

I have a column "A" of dates in the typical xx/xx/xxxx format. Then I have column "B" of years in the xxxx format.

I want to apply a countif formula in column "C" that counts up all the occurrences in column A that matches the year in column B.

For example:

column A has: 05/01/2013, 8/01/2013, 12/12/2013, 1/01/2014, 1/03/2014
column B has: 2013
Column C (the countif formula) has: 3 (counted all the 2013 occurrences in column A)

How do I write that countif formula? Thank You,

[Richard Buttrey]

Hi,

One way would be to use a helper column, say column D. In D1 enter

=Year(A1)

and copy this down. Now with your date of 2013 in B1, in C1 use:

=COUNTIF(D:D,B1)

HTH

[penumbra547]

Richard,

thank You. That worked perfectly!