Excel Spreadsheet Problem

dyadic317

New Member
I am trying to count text in specific cells, not in a range. How can I accomplish this? Specifically, I am trying to count the occurences of "UL" in only cells H3, K3 & O3. Please help, thank you.
 

My Computer

roy69

47,65,65,6B
Vista Guru
Gold Member
you can use a nested if statement, look here :-http://www.microsoft.com/office/community/en-us/default.mspx?&lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.excel.worksheet.functions&p=1&tid=9737BEA0-60A8-49E7-B96C-2B74A27333AE&mid=9737BEA0-60A8-49E7-B96C-2B74A27333AE
 

My Computer

System One

  • Manufacturer/Model
    Self Built
    CPU
    I5 3570K
    Motherboard
    Gigabyte Z77-DS3H
    Memory
    4 x 4GB corsair ballistix sport DDR3 1600 Mhz
    Graphics Card(s)
    Gigabyte Geforce GTX 660 TI
    Sound Card
    creative x-fi
    Monitor(s) Displays
    Primary CiBox 22" Widescreen LCD ,Secondary Dell 22" Widescreen
    Screen Resolution
    Both 1680 x 1050
    Hard Drives
    2 x 500G HD (SATA) 1 x 2TB USB
    PSU
    Corsair HX 620W ATX2.2 Modular SLI Complient PSU
    Case
    Antec 900 Ultimate Gaming Case
    Cooling
    3 x 80mm tri led front, 120mm side 120mm back, 200mm top
    Mouse
    Technika TKOPTM2
    Keyboard
    Logik
    Internet Speed
    288 / 4000
    Other Info
    Creative Inspire 7.1 T7900 Speakers
    Trust Graphics Tablet

roy69

47,65,65,6B
Vista Guru
Gold Member
The if function works for letters and numbers,

Here is the solution to your problem

=IF(H3="UL",IF(K3="UL",IF(O3="UL","true","false")))

This will tell you if all 3 are UL

use;
countif(h3,"UL")
countif(k3,"UL")
countif(O3,"UL")
SUM(range of countif)

The countif statements can be away from the main data or even on a different worksheet.
Use the Sum statement where you want the label for the amount of occurances linked to the countif statements.

ul ul ul "=COUNTIF(H3,"ul")" "=COUNTIF(K3,"ul")" "=COUNTIF(O3,"ul")" "SUM(d5:d7)"
 

My Computer

System One

  • Manufacturer/Model
    Self Built
    CPU
    I5 3570K
    Motherboard
    Gigabyte Z77-DS3H
    Memory
    4 x 4GB corsair ballistix sport DDR3 1600 Mhz
    Graphics Card(s)
    Gigabyte Geforce GTX 660 TI
    Sound Card
    creative x-fi
    Monitor(s) Displays
    Primary CiBox 22" Widescreen LCD ,Secondary Dell 22" Widescreen
    Screen Resolution
    Both 1680 x 1050
    Hard Drives
    2 x 500G HD (SATA) 1 x 2TB USB
    PSU
    Corsair HX 620W ATX2.2 Modular SLI Complient PSU
    Case
    Antec 900 Ultimate Gaming Case
    Cooling
    3 x 80mm tri led front, 120mm side 120mm back, 200mm top
    Mouse
    Technika TKOPTM2
    Keyboard
    Logik
    Internet Speed
    288 / 4000
    Other Info
    Creative Inspire 7.1 T7900 Speakers
    Trust Graphics Tablet
Top