I have a question. I have a column with only the figure 1, but many. Some are
hidden (invisible) and some are not. What I want to do is to summurize the
figures that you can see on the screen, and note the hidden ones. So lets say
I have 4 figures  that are not hidden and 2 which ...

Hi I have a spreadsheet whereby I need to add numbers together from
areas.
A1:  1171
A2:  4202

I put in =sum(E1+G23) & the total in the cell where I put the formula comes
up(2 or 3) cents off? It comes up short when I put =sum(E1*G23). Not al the
time but off & on. I have to add stuff on paper to check that the total is
right. I should not have to take all this time to use ...

I am using Excel 2002 SP3.
When I place a jpg into the header and email the document to a customer,
they cannot see the jpg when they use print preview.  Is this because they
could be using an older version of Excel?

Dear Gentlemen,
I have the following problem.
I have the following list in cell range A1 to A3
Milling

I have say =sum(E1+G3)
E1 = $10.00
G3 = 8
The cell I put this formula in comes up (2 or 3) cents off.

Can anyone help? I need a excel template or ideas of how to create a
stock balance sheet that can be updated when items are removed from
stock. because we have such a large stock, it is a pain going through
each sheet looking for an individual part number to alter its quantity.

I've got a sheet that gets appended to regularly but have to do a lot
of fiddling to make sure the formatting is correct, calculated fields
get added and chart series ranges collect all the data every time I add
a new row.

A macro has stopped operating correctly when a client updated to Office
2003. Trhough VBA, when copying from one workbook and pasting to another a
UK date is being converted to US format when pasted. Appears to be a bug.
E.g. 10/04/2006 being converted to 04/10/2006. This then ...

Employee timecard (daily, weekly, monthly, and yearly)
I am using this template to track hours. I need to get it to start adding
overtime hours at 40. right now it just adds hours. can you help me with the
formula to get it to do this. It is a great template for me. Thanks, please ...

Does anybody know if there is a way to customize the print options that
aplies in new workbooks.
I want my (every) new file to print landscape and scale to fit.
Regards

I'm using the Text to Columns wizard to separate out a comma delimited
address field.  Works great, but afterwards the data doesn't always
match with the correct column, i.e. city, state, zip.
For Example, after the split I end up with the following scenario:

When I type a nymber, it gets converted to that number divided by 100. For
example if I type 100 in the cell, it gets converted to 1.00.  How do we set
it right?

I am preparing a construction budget for some condos and I'd like to
have a simple way to choose between different options for some of the
line items (i.e. granite countertops instead of tile)... each would
have its own cost implication and affect the bottom line.  Any ideas?

Is it possible to use
IF()
ELSE IF()
ELSE IF() block? and how to use?