Trying to set up the following computation in excel.
=Sum(abs(An - Bn)+abs(An+1 - Bn+1)+...+abs(Am - Bm))
where the row range varies from n to m.

I want to create a statement to calculate appropriate federal tax withholding
amounts based on gross income, which varies each pay period. The federal tax
tables specify minimum & maximum salary ranges, a withholding allowance,
multiplier percentages and a fixed withholding ...

Hi, I need help to setup the VLOOKUP function for a project, however, every
time I try to do it, it says, #NA.
I need to use VLOOKUP to pull in the costs for a list of products.
The costs are located in another file called ‘06 Standard Cost Data File –

I need to make a number in one cell, 0,108,250.500, to be without commas or
decimal place, 0108250500, in a new cell. I can make the change with no
problem to take out the commas and decimal (and this is done with a simple
macro, as there will be a long column of these numbers to ...

I have an excel spread sheet with negative and  positive numbers and when I
do calculations in excel, the negative numbers are subtracted from the
positive numbers for a total. However, when I try to use a pivot table, 2
negative numbers are added together and reported as a ...

I need to change text from "A" to "B" as shown below in about 900 cell  
entries in excel 2000 ver (9.0.8961 SP-3) Suggestions please!!!
A: 21071303129W300
B: 21/07-13-031-29W3/0

I made a sheet in Excel of 9 columns, when I print them, I only need to see
printed columns number 1, 2, 3, 7 and 8 in one page and like if column number
4, 5 and 6 weren't there. Is there any way to do this, without doing "right
click" then "hide" the columns and then print, and ...

I'm interning at a company in Jacksonville, Florida and I've been sent on a
'wild goose chase,' so please...bear with me on the details.
We have an internal customer who is looking to export the file headings for
any particular folder in Windows Explorer on XP to an Excel ...

Trying to write an IF statement to return one value if the cell is empty and
another if not.  For example, if the cell is empty, return the value above,
if not empty, return the value itself.

I need to be able to add data in a column, and some of the cells in that
column have an #N/A in it, resulting from a VLOOKUP. How do I add the data in
the column, and have it ignore the #N/A?

Thanx for replying me in time for my earlier question.
I have a data of 15000 rows.  My problem is there are spaces of a row or two
between each records.  I could have sort it to remove the blank rows in
between.  But do not want to change the order of the records.  pls suggest

Is there one formula that will do the following?
A1:A3 = 7/9/2007 AND column C1:C3 =IN, then count (ADD) B1:B3
BUT if column C1:C3 = DD then subtract from the count of B1:B3
AND if colmun C1:C3 = OT then subtract from the count of B1:B3.

I keep reading the Excel Help and rubbing my eyes and looking at Excel and
rubbing my eyes some more . . .
I need to prevent users from changing the names of my worksheets.  I have a
few formulas that "hard code" sheet names inside INDIRECT formulas, so any

Is there one formula that will do the following?
A1:A3 = 7/9/2007 AND column C1:C3 =IN, then count (ADD) B1:B3
BUT if column C1:C3 = DD then subtract from the count of B1:B3
AND if colmun C1:C3 = OT then subtract from the count of B1:B3.

We can extract numbers on an "aging data" tab, but a subsequent pivot
table has the days listed in columns in either one of the following
order:
Over 1 year    90    60    365    30    270    180