I feel like an idiot but I couldn't do something that should be easy.   I
have columns in a spreadsheet like the ones below.  I want to find all of the
items with a "1" in the left hand column and total the corresponding values
in the right hand column.  I've been trying to ...

Is there a function or something I can use to hide a cell based on the value
of another cell?
For example, I want to hide the information in cell B5 if cell A5 doesn't
have any information in it

Is there a way that you can hide the value of a cell depending on the value
of the cell directly in front of it?

When I open excel or any other excel spreed sheets, the file opens weird.
There is no information and the zoom (size) is on the top with no other
functions. Almost like is is upside down, with no menu bar.
Anyone else get this?

I'm trying to create a formula that says "if column a=81500 AND if column
b=1885, then do a sumif(columnC,"<529999",">539999",columnD).
So, basically, I want to do a sumif function but put restrictions on it and
only add up those numbers in column D that meet the criteria.

Downloaded some HTML spreadsheets from a webpage. I cannot seem to rid
those LINKS from it inside EXCEL. Is their some shortcut to doing
this?
If not, I have MANY hours ahead of me, thank you very much....

I'm not too familiar with VLookup and I'm trying to find results in one
workbook and divide against a result in another workbook. Does anyone know
what the formula would look like for that. Here is a scenario below.
Workbook 1 - Invoice Charges by location (Texas)

I am vlooking up costs to enter into my spreadsheet.  In column I is my
current cost.  In column J is my last cost.  If we are out of inventory, our
computer gives us a 0 cost in current.  When this happens I want the last
cost to be reported in it's place.  My formula will give ...

I was told that Excel can use word formulas.  Is this true?  I have one
worksheet that has our proposals which adds up the sums of different cells.  
I need to create an easy way for my salesmen to include sales tax.  Seems
pretty basic, but not every city has the same tax rate ...

Here is a sample of the data that I am working with:
Skier                   Round 1    Round 2    Best Round
Competitor 1              109    105.5    109
Competitor 2    104    109    109

I have a complicated master inventory spreadsheet from which I need to
generate shorter reports for items currently in use.  My column headings are
as below:
A    Product

I'm trying to set up a function in "data validation", "other".
=IF(OR(H1="Agency",H1="Employee Traveler")," ",0.5)
So far this works. However, I want to modify it to allow the user to input
any amount if it returns false.  Is there a way to do this within the

COLUMN:   INVOICE #         INVOICE DATE         AMOUNT$
                101                   9/18/07                  100    
        101 TOTAL                                              100  
                102                   9/20/07                   200

Is there a way to consecutively add bi-monthly dates to a spreadsheet?  Kind
of different because the 15th will always be 15.  It's the last day of the
month that changes each month.  This would be for people who are paid
bi-monthly so the dates don't have to be input each time.

I'm using Excel 2003.  My spreadsheet has 9 Department tabs, each with 10
Funding Source Categories columns and 20 Expense Category rows.  Not all the
Departments use all of the Funding Sources or Expense Categories.  I have a
Master Pivot table based on all Departments combined: ...