I'm using Excel 2007 and would like to apply the TRIM funtion to the entire
spreadsheet.  I know how to do it for a given cell and then copy it to the
rest of the column but would like to do a whole spreadsheet at the same time
if possible.

I have three criteria with this formula and it brings back a $0 value, when I
know there is a $ amount that should have be calculated.  I am working in one
workbook and linking to another.  What have I done wrong?
=SUMPRODUCT(--('[Workbook Name.xls]Name'!$O$2:$O$37="P") ...

Every day I process microfilm for 3 hours, Monday - Friday.  I am tracking
the time that this is done, and averaging the time at the end of the week in
a spreadsheet.  (I am using Excell 2003)  If I work on the microfilm 3 hours
for five days the average for the week is 3 hours - ...

I have the following formula:
=SUMIF(Data!$X$6:Data!$X$5000,">="&0.01,Data!BF$6:Data!BF$5000)-SUMIF(Data!$X$6:Data!$X$5000,">"&0.02,Data!BF$6:Data!BF$5000)
This is to look in cells x6:x5000 for any percentages that are greater than
or equal to 1% and less than 2%.  However, it is ...

Working with a cash worksheet that I list deposits and expenditures.  Need to
add accounting code column with an assigned number dependent on
nature/description of expenditure.  Is there a way for certain key words (in
some cases multiple key words) to trigger an accounting code ...

I want to create a table with income figures and then look up values based on
household size that is calculated and then return the column lable. For
instance, a 4x4 table with family size 1, 2, 3, 4 and column lables of 100%,
125%, 150% and 175%. The grid is filled with income ...

Can I please get additional help with the post that I posted earlier.
My first question was
If G37=daily, then F37 cannot be greater then 1.  If it is greater then one,
then an error message will show in K37.

I am better at VBA than worksheet formulas. :shrug:
I have this formula in a cell:
'======
=MID(D6,4,FIND("-",D6)-4)

Thank you in advance for the advice! In a worksheet I would like to average a
column of times, the cells are like this:
11:30
11:20

Hi--
I have a spreadsheet where I have a column letter(s) entered in cell
AM2.  For example cell AM2 has the text "df" to represent column df.
I am trying to write a formula that will allow me to access data in

i am trying to calculate how many days between 2 dates that excludes
holidays and weekends.  Is there a formula for that.  Thanks,

Does anyone know how to write a formula which will return the formula
in another cell as a string?
e.g if A3 contains the formula A1+ A2, I want to write a formula in B3
with will return the formula in A3 as string '= A1 + A2. Hence the

how can I force excel 2003 to ignore in calculation empty cells but not
cells with zero.
For example:
the formula =If(d4=0,e4*f4," ")

I am new to Excel programming, but am very familiar with Word.  In Word, you
can search for a particular location in a document using the Bookmark
function.  Is there a similar option in Excel?  If so, how do you create it
and search for it.

I have basic knowledge of excel and have been reading myself nuts with
different functions. I am trying to put together a spreadsheet that will give
me live Inventory availability. I've tried all kinds of functions in all the
totals row to get the totals in "Available Inventory" ...