I have a workbook containing several worksheets and a summary sheet that
refers to all the other sheets with a 3D reference.  I need to fix the 3D
reference just as I can fix a cell address by entering $A$5 (eg).
So my reference would appear as =SUM($Sheet1:$Sheet10:B5) - this ...

Does anyone know how to calculate working hours between 2 dates ?
The 2 examples I found on the Internet does not work
For example this one:
=IF(AND(INT(StartDT)=INT(EndDT),NOT(ISNA(MATCH(INT(StartDT),HolidayList,0))))

Hi I have tried to find out from earlier messages but failed.
I am looking for the following
I need to fill in payments from our customers. In the left column I
choose via combo box the currency of the invoice. How to get the cell

I have a sheet (Study Sheet) that has from 1 to 10 Studies across and 1 to 30
Cases down.
        Study 1                    Study 2   
    Part    Test    Results            Part    Test    Results

This small equation is kicking my butt.  Could someone enlighten me.
I am simply trying to compare 2 dates if the date in cell c2 is less that
"12/31/08" then put the value , or else put " future "
This is what I came up with

As probably everyone in the known Excel universe knows by now (except
for people like me who suspected this but didn't pay enough
attention), if you exit Excel normally without saving your work there
is no "recovery" file to be recovered, nor .bak file to activate.  The

I have a date in cell A1, How do I conditionally fill cell G5 with a fill color?
Thank for any assistance,
Ben

I have an excel 2003 file that was password protected to open.  Is there a
way to reset this?   The employee left
a few months ago and this wasnt on his list.  We are also attempting to
reach him as well.  Just in case we cant. \

I want to install Excel 2003 in parallel to Office 2007. How can I do that
and what steps do I have to follow (i.e. order of installation, a repair of
Office 2007 afterwards, etc..) and will it create issues with Office 2007?
Explanation:

Is there a way to customize my mouse settings within Excel?
My mouse has a wheel button that I would like to set to the Excel
"calculate" command.
Outside of Excel the wheel button is set "backspace" which I use in my web

Using Excel 2002, I am analyzing sets of numbers. One statistic Ii
look at is the Mode. If the set of numbers has more than 1 mode, how
can I get the Mode function to return the lowest Mode?
Thanks,

In Excel 2007, I am updating a worksheet developed by someone else.
I can't get a column of email addresses to display times new roman, 12.
I have reset the page default, I have formatted just the column containing
the email addresses and nothing seems to work.

Excel 2002 SP3
Win XP Pro SP2
Hi,
Is there a utility or a way for me to find errors in a workbook (xls

Hi, I'm having trouble linking to an external .csv file located on a
website. Essentially I'd like to link to the 1st 3 columns of the
following.
http://www.asx.com.au/asx/downloadCsv/ASXListedCompanies.csv

I have several workbooks with a sheet in for each day (W1Mo etc) which all
link to a daily totals sheet in  a seperate workbook.  What I've done is
named the total figure cell in each column and then linked that to the daily
sheet, but I have approx 120 named cells per workbook.  ...