Is there a way to retrieve the text content of a cell in the same way that a
SUMPRODUCT function will retrieve numeric content? If not is it possible to
retrieve the ROW number of the cell in a SUMPRODUCT (?) in order to use it in
an INDIRECT function?

I am trying to set up a formula to count the number of data occurances each
quarter. I currently am using the function :
=COUNTIF('Tower Age'!B6:B80,"12/31/2005")
but that only gives me the occurances of that date.

have spreadsheet with error categories which uses a dropdown list the user
chooses from and the error categories are populated with a "1" if my if/mid
formula is true.  however, pivot table results are wrong... how to correct??

In calculating commissions, I come accross #value! message when certain
criterias are not met. I want to replace this sign with 0. How do I do
this? Becuase this error message is in the middle, the bottom line
figures are not correct. Help

Hi I'm currently running office 2000 and trying to get vlookup to work
properly.
I have 10 tables which must be referenced from one formula.
The formula must pick which table to use (currently have that working)

I'd like for Excel to return the colomn "name" based on the lowest value in
the sequence.  For example-
Columns are A, B, C, D, E, F, G
Column names are in row 1

I cannot get the excel loan payment program to calculate correctly.  I've
even used the specific example in Help and I get a completely different
answer.
Any ideas?

I have data in cells that are formatted in a code.name format
I need the name, but not the code - the code is always 5 characters.
The name lenght is random.
How do I get rid of the code and keep the name

I'm having some difficulties getting this done. I would like to lookup values
in first two columns (category and sub category) in a range in a separate
table with 3 columns (match first two columns in first sheet to first two
columns in second table, and if both matches, return ...

I want a SUM formula to occur in cell B34 that includes the following cells,
providing they are not blank.  O12,O13,O23,O24,O36,O37,O45,O46,O56,O57,O65
and O66.  These cells have a drop-down selection of numbers from 1-5, and
have data validation and conditional formatting set to ...

I want to create a column in my worksheet.  What this column will tell me is
that whatever text in column A that has the word fullfillment will return
fullfillment to my column, whatever text in column A that has the word Marin
will return Marin to my new column, etc.

Hi......big question here:
please look at this chart:
          SHEET1                                          SHEET2
   Shape     |     Color                         Shape     |     Color

I have a large sheet with over 15,000 lines, one for each customer.
Problem is that one column includes:
B1
FirstName LastName NNNN Any St Suite NNN City STATE ZIP

=IF(ISERROR(F16-K16),"",IF(SUM(F16-K16>0),"",SUM(F16-K16)))
Cells F16 & K16 can either contain a "Null String" ("") or a number created
from another IF statement , from these 2 Cells I need another calculation,
if the error "#Value" is made I want it to be blank, If the number is ...

We use large Excel files with filters.  I waste time scrolling across columns
to make sure what filters are still on or off.  Is there a feature in Excel
where you can
look to see what columns have filters on them?