Overclock.net › Forums › Software, Programming and Coding › Other Software › Formula to count instances in a spreadsheet
New Posts  All Forums:Forum Nav:

Formula to count instances in a spreadsheet

post #1 of 4
Thread Starter 
Im trying to calculate the number of times a word appears ina column in a spread sheet. Its to calculate a ratio of passes to failures. I want to count how many times "PASS" occours, against "FAIL"

I have them going down column J

I have tried = COUNTIF($J:$J,'PASS') and = COUNTIF(J1:J100,'PASS') but it just returns #name? in the cell.

Ideas?
Dell Optiplex 960
(13 items)
 
  
CPUGraphicsRAMHard Drive
Core 2 Quad Q8400 XFX 9500GT 1GB 8GB 2x Raptor 160GB - RAID 0 
Optical DriveOSMonitor
DVD-RW Windows 7 Ultimate x64 SP2 2 x 2207WFP 
  hide details  
Reply
Dell Optiplex 960
(13 items)
 
  
CPUGraphicsRAMHard Drive
Core 2 Quad Q8400 XFX 9500GT 1GB 8GB 2x Raptor 160GB - RAID 0 
Optical DriveOSMonitor
DVD-RW Windows 7 Ultimate x64 SP2 2 x 2207WFP 
  hide details  
Reply
post #2 of 4
I usually create a column with the criteria, match it in the function arguments box, then hide the criteria column I created.

ends up like this: =COUNTIF(C2:C12,A2)

with C2:C12 being the range and A2 being the criteria.
    
CPUMotherboardGraphicsRAM
Q6600 3.2 EVGA 780i SLI EVGA GTX 260 SC 6GB (2x2G 2x1G) G.Skill 
Hard DriveOptical DriveOSMonitor
2xWD 250gb sata 16mb RAID0 - 500gb ext. Samsung sata burner Vista Ultimate 64 SP1 Samsung 2443BWX 
KeyboardPowerCaseMouse
G15 Antec Signature SG850 Cosmos S Logitech G5 
Mouse Pad
SteelPad QcK 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Q6600 3.2 EVGA 780i SLI EVGA GTX 260 SC 6GB (2x2G 2x1G) G.Skill 
Hard DriveOptical DriveOSMonitor
2xWD 250gb sata 16mb RAID0 - 500gb ext. Samsung sata burner Vista Ultimate 64 SP1 Samsung 2443BWX 
KeyboardPowerCaseMouse
G15 Antec Signature SG850 Cosmos S Logitech G5 
Mouse Pad
SteelPad QcK 
  hide details  
Reply
post #3 of 4
Thread Starter 
Thanks Polo, worked a treat! Rep for you mboy
Dell Optiplex 960
(13 items)
 
  
CPUGraphicsRAMHard Drive
Core 2 Quad Q8400 XFX 9500GT 1GB 8GB 2x Raptor 160GB - RAID 0 
Optical DriveOSMonitor
DVD-RW Windows 7 Ultimate x64 SP2 2 x 2207WFP 
  hide details  
Reply
Dell Optiplex 960
(13 items)
 
  
CPUGraphicsRAMHard Drive
Core 2 Quad Q8400 XFX 9500GT 1GB 8GB 2x Raptor 160GB - RAID 0 
Optical DriveOSMonitor
DVD-RW Windows 7 Ultimate x64 SP2 2 x 2207WFP 
  hide details  
Reply
post #4 of 4
Cheers.
    
CPUMotherboardGraphicsRAM
Q6600 3.2 EVGA 780i SLI EVGA GTX 260 SC 6GB (2x2G 2x1G) G.Skill 
Hard DriveOptical DriveOSMonitor
2xWD 250gb sata 16mb RAID0 - 500gb ext. Samsung sata burner Vista Ultimate 64 SP1 Samsung 2443BWX 
KeyboardPowerCaseMouse
G15 Antec Signature SG850 Cosmos S Logitech G5 
Mouse Pad
SteelPad QcK 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Q6600 3.2 EVGA 780i SLI EVGA GTX 260 SC 6GB (2x2G 2x1G) G.Skill 
Hard DriveOptical DriveOSMonitor
2xWD 250gb sata 16mb RAID0 - 500gb ext. Samsung sata burner Vista Ultimate 64 SP1 Samsung 2443BWX 
KeyboardPowerCaseMouse
G15 Antec Signature SG850 Cosmos S Logitech G5 
Mouse Pad
SteelPad QcK 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › Formula to count instances in a spreadsheet