Still hunting for a solution to a problem posted earlier.  I have a data
table that contains a list of donations, with the name of the donor in column
A and the amount of each donation in column B.  Some donors gave more than
once, and I need to be able to calculate their ...

=F51*Summary!$J$18/12
This is a formula in a spreadsheet that I am using.  It figures interest.  
The interest rate has changed and I am not familiar with "Summary" or $ or J
or $ or where the 18 comes from.  I know F51* and I know /12.  Can someone

I am using SUMIF for returning number values that meet certain criteria.
Now I want to return text, instead of numbers, that meet certain criteria
and am having trouble.  Also I do not want a zero to return where there is no
value.

I am looking for a formula in ColC that will return TRUE is the right
character in COLA is 0 (zero).
ColA    ColC
123    FALSE

I am having problems coming up with a formula
Here is my scenario
If A2:A5 = Apples and B2:B5 = Oranges, then count the number of oranges in
Column B

I'm trying to use the SUMIF function with criteria that value must be >30 and
<=60.  How would I code that with this function?

I need to have a total cell for a large spreadsheet I'm working on (150+lines
of data).  I need to put in a formula that will add the amount in Column B if
the word in the Column A says "Retail".
Example:

I am not sure how to get the results I am looking for, and if it is better to
use an if statement or a lookup funtcion (which I have never used before).
Data Information:
Column "AO" contains one of 5 names

In Row T6 I enter the first day of the pay week (Sunday) in the form
5/4/2008
it appears as May 4 2008
Then In row D13 the last day of the pay week(Saturday) then appears as

I need to report on aging of invoices based on when the service was incurred
vs. when it was actually paid.

I am trying to import categorical data into a spreadsheet. I need the
categorical data to import as numerical values (i.e.  white = 1, black = 2,
hispanic = 3, etc.)
Is there a way to do this using conditional formatting? If not, please offer

I am new to Excel, I have a "for dummies" book but what I need, I have not a
clue where to look.  I have Excel 2007, OS XP.
I have 1000 plus rows of info the columns are titled
A              B          C         D

I would like a cell to turn yellow if I start a sentence with an *, if there
is no *, then no color.
How would I phrase this in the conditional formatting option?

Legend:
a1    b1
TX    8.25%
MA   5%

I am trying to decifer a spreadsheet prepared by someone who has left the
company.  They used the following cell reference, which appears to reference
an outside spreadsheet without using the full spreadsheet name, ='AR
''06'!G414.