I want to use sumif in the following way :
SUMIF(purchases!O18:purchases!O500,"=b21",purchases!
Q18:purchases!Q500)
and not :

this is for excel 2000
excel crashed while doing some vba code testing
now when re-opening the sheet where crash occurred i get the file is already
open by myself,

I am looking for something that will find the last cell of
data in a column, here is what I want to do
the function I have is
=if(a1=0,0,(b1-$cS10)*d1)

Have used Excel, however not an expert. My document list was in alphabetical
order, however within the last week, it is not. Don't know what I did to get
in a random order or how to correct this problem.

I just came out of a Mac and when I protected a spreadsheet I could hit Enter
to move to the next unprotected cell. In the PC version, enter moves down a
cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
to change the function of the enter key?

When opening an existing file, the default is to view all file types.
However, in Excel it defautls to .xls files. How do I change the Excel
default to view all file types without have to change it everytime?

I would like to create a check mark box in my excel document so that I can
click on it and a check mark will appear.  I would then like to create a
formula that would add a dollar amount in the total column if the checkmark
is present. Could someone please let me know how I can ...

How do I change the default settings in the Find dialog box? The default
search is by Rows. I would like to set it to Columns, Look in Formulas, Match
Case set to Yes, search in Entire Cell.

I have formatted a column to show fractions, but I want that column to
display even denominators, highest of which is 32nds.  Sometimes, I get 5ths,
31s, etc...  Can anyone shed some light on how I can force Excel to round
only to even fractions (quarters, eighths, sixteenths, ...

Is there an easy way to put page numbers on worksheets?  The MS instructions
did not work.
Thanks
Anne

We have a number of spreadsheets that retrieve data from an access database
that, in turn, uses linked tables to our accounting system via ODBC.  We have
a terminal server that users in the remote office use to access this
accounting system, but it does not currently have office ...

I have just moved from Office 2002 to Office 2003, and I cannot figure out
how to enable the merge and compare feature under tools in Excel.  Please
help. Thanks!

My problem is
I have 2 network printers, A and B, A is set to be the default printer.
I work on an Excel doc and choose B to print out.
I want to know how to make this file to memorise the last used printer B so

I am using multiple monitors and would like to to have a seperate workbook
open on either monitor so that i can look at either monitor and see the
different workbooks.
At the moment the workbooks open in the same window and they cant be split.

I am trying to set up a workbook for my rental property to keep track of it
for tax purposed....where is a good template for this?