Vista - Excel Spreadsheet Problem

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.

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

Thanks but I'm dealing with letters not numbers.

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.

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