CODEWITHSUNDEEP
excelfunctionformula
user3301317
user3301317

Reputation: 1

Excel: Count Specific Words In Multiple Cells of a Column

I have 200 cells in column A which contain a list of dates:

January 14, 2014
January 18, 2014
March 13, 2014
April 15, 2014
June 20, 2014
and so on...

What function would I use in order to count the total number of times "January" occurs in column A?

Upvotes: 0

Views: 1189

Answers (2)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35863

If your data has Date format, try this one:

=SUMPRODUCT(1*(MONTH(A1:A15)=1))

Note, if your range contains empty cells, you should use formula, provided @barryhoudini in the comment below.

Upvotes: 1

Pankaj Jaju
Pankaj Jaju

Reputation: 5481

Try the following formula

=COUNTIF(A1:A200,"January*")

Upvotes: 0

Related Questions