Counting word occurrences

fillupbrun

New Member
Joined
Jan 6, 2012
Messages
6
A1: Win */* Over *
A2: Win */* Over *
A3: Loss */* Under *
A4: Win */* Push *
A5: Win */* Over *
A6: Win */* Over *
A7: Win */* Over *
A8: Win */* Under *
A9: Loss */* Over *
A10: Push */* Over *
A11: Loss */* Over *

I want to count how many times the word Over occurs and then count how many times the word Under occurs.
 

VBAdude

New Member
Joined
Jul 21, 2011
Messages
40
Try this:

=COUNTIF(A12:A22,"*Over*")

=COUNTIF(A12:A22,"*Under*")

In the first argument, where I have A12:A22, put the range relevant to your example.
 

Leith Ross

Well-known Member
Joined
Mar 17, 2008
Messages
1,876
Office Version
2010, 2007
Platform
Windows
Hello Fillupbrun,

This formula will return the count in a single cell. It is an array formula. You must use Control+Shift+Enter to confirm the formula after it is entered.

=SUM(--(ISNUMBER(SEARCH("Over",A1:A11))))
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,895
Office Version
365, 2010
Platform
Windows
Why would you use that over COUNTIF?
 

Forum statistics

Threads
1,084,738
Messages
5,379,520
Members
401,611
Latest member
jmathews440

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top