Why does this:-
=IF($A$29=0,0,IF($A$2="",0,SUMIF(OFFSET(A31,,,$A$29,1),$A$2,OFFSET(F31,,,$A$29,1))))/$A$29
produce a different result tothis?:-
=IF($A$29=0,0,IF($A$2="",0,SUMIF($A$31:$A$3000,$A$2,F31:F3000)))/$A$29

I have the 20 following ranges that has formulas and I need to copy them to
another work book at the same location.
The ranges are:
H9:H12

Does anyone know of a way to get a cell value in a page header without
using VBA?

I have a range of data from A16 to K??.
In cell A15 I have a COUNTA function which returns the number of rows of
data (the range is continually being added to).
In F10 I would like to have an average function for the numeric values in

Thanks for looking at my post :)
I am stuck on an 'IF' formula.  I am trying to make the formula
recognise if a cell is more than or equal to 10 hours.  See cell
details below:

I have one cell, which is the result of a calculation between 2 figures, and
the cell next to it needs to be the same number - but the direct opposite.
eg.
if the result of the calculation is -47000, the cell next to it needs to be

using 2003.  I can synchronize the scroll on 2 spreadsheets by using
"Windows.CompareSideBySideWith"
I need to synchronize three sheets (ie "Last Month", "Current Month",
and "Delta").  Is there a way to do that?

I would like to know how I can take different cells (non concurrent)
and string them together in another cell with separators. The
CONCATENATE function can't do this. The end result that I am looking
for is to select a number of cells using a userform and listbox with

How do I set up make the filename appear at the top of Excel document like it
does in Word?

I am trying to enter 10,418 in a dollar amount, when I leave the cell it
changes to this :########. How can I fix this?

Hi, I've got a large survey data-set in Excel 2003. Some values are
pure text, some are numbers but were recorded as text. There are also
many blanks in each collumn.
So, I am trying to convert the numbers from text format to a number

Hi, The file has date formate as MM/DD/YYYY and I want to keep it
that
way. Is there anyway the file can be sorted by only MM? I am trying
to

How I can make a cell contact with another cell on another sheet and it will
changes when day changes.
example I have cell A1 sheet1 contact with cell A2 sheet 2 and cell A1 sheet
2 is the date when the date change A1 sheet 1 will auto change to B2 sheet 2

At the top of my spreadsheet I want to create a row that is the name or
title. I want it locked and unchanging once created.

I thought it was possible to display three sheets in the same workbook by
using Windows|Arrange, then checking Windows of Active Workbook.  But NO!
Impossible?  James