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,
Hi,
One way would be to use a helper column, say column D. In D1 enter
and copy this down. Now with your date of 2013 in B1, in C1 use:
Please Login or Register to view this content.
HTHPlease Login or Register to view this content.
Last edited by Richard Buttrey; 10-29-2009 at 01:40 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard,
thank You. That worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks