Comments on: How to count words in Excel

Comments page 2. Total comments: 33

1. 

   Chris says:
   2017-04-11 at 2:29 pm

   Hello,
   I am trying to find a method to use this formula:
   =SUM((LEN(Page_1!H:H)-LEN(SUBSTITUTE((UPPER(Page_1!H:H)),UPPER(A3),"")))/LEN(A3))

   And
   Have it only calculate based on a date range from A:A (date/time formatted)

   How can I do this?

2. 

   rizwan says:
   2017-02-28 at 4:37 pm

   hi in excal i want to this date format 2016-06 to do less 1 after less 1 new value 2016-06 and if my value 2017-01 after calculate my new answer 2016-12 tell me how it possible this

3. 

   sally says:
   2016-10-11 at 9:47 pm

   Can someone show me the formula needed to count how many times certain text appears in one column (the text can appear multiple times in one cell or just once) while meeting criteria from another cell.

   For Example:

   YEAR ........ACTION TAKEN
   2010 .......Case 1: No Action, Case 2: No Action
   2015 .......Case 1: Suspension, Case 2: Termination
   2016 .......Case 1: No Action
   2012 .......Case 1: Letter, Case 2: Termination
   2010 .......Case 1: Suspension, Case 2: No Action
   2010 .......Case 1: Letter, Case 2: No Action, Case 3: No Action
   2013 .......Case 1: Suspension

   I need a formula that will count the number of times in 2010, No Action was taken in cases. The answer is 3.

   This formula:

   =SUM((LEN(range)-LEN(SUBSTITUTE(range, word,"")))/LEN(word))

   Gets me halfway there. Now I need to figure out how to only count the words when the YEAR row is 2010.

4. 

   Jenal says:
   2016-06-27 at 10:11 pm

   I Have been following this site for several month. I found it give me complete and deep explanation about some excel feature. Thanks