##### 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.

## System One

#### 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

## 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

##### New Member
Thanks but I'm dealing with letters not numbers.

## System One

#### 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)"

## 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