Hello I have a very large sheet and I would like to add subtotals at each
Order type. Column B and C will have Sum and Column D and E will have
Average. It's possible to do it at once? Subtotals gives only one option
Example:

I need to automatically number rows in a spreadsheet.  I've tried the ROW
function but unless I start at Row 1 and then need to remove a row in the
middle of the spreadsheet I get a #REF error.  How can I start row numbering
in Cell A3 and if I need to delete a row somewhere in ...

I am trying to find a formula to calculate an amortization schedule where the
interest is compounded semi-annually rather than monthly (that's how we do it
in the Great White North).
There are lots of amortization templates but they all seem to calculate

How can I copy or convert excel data from an computer which has excel 2007 to
a computer which has excel 2003?

when I enter my product key it says "invalid entry?

I have a pivot table that is basically saying how much business a sales
person has closed per quarter over an 18 month period. The data is coming
from an automatic export from our sales database, so I am unable to change my
source data. See example of pivot table:

i need your on this
I have one coloum fill of sales dates  figures from year 1999 till 2007
I need formula to give sales figures  form month August 2004 or April 2002
date formated 8/19/1999

I have a table which shows the languages spoken by children in our school.
In column B are all the possible languages, Column C shows the number of
chidlren who speak that particular language. WHen I break this down into
class, there are some rows which have a blank cell under ...

Hey folks.
I have a wee query. I have a spread sheet with two columns of data
(they're item codes.) I need to somehow highlight the item code in one
column if it exists in the other.

I am trying to copy a list of film titles I have in one worksheet contained
in one workbook to another worksheet in another workbook.  There are no
formulae involved, it is not a mathematical process, simply information.  
There must be a link between the 2 worksheets so that any ...

I have copied a great pop up calendar from someone else and have got the pop
up calendar to work.  However, the months and dates do not appear correctly.  
Please could you tell me where I need to look to check this information.
Many thanks,

I have Worksheet1 w/ hyperlinks to other worksheets in the workbook.  I have
Worksheet1 protected, & the hyperlink cells locked.  When protected, the
hyperlinks don't work, and checking the "Insert Hyperlink" option (when
turning-on the worksheet protection) still won't allow the ...

i need to be able to sort a month column by month order instead of
alphabetical order
Is this possible?

My one cell have today date with formula =Today() and i want total remaining
day in Numbers from any given future date. Exp. I put in one cell 01/01/2008
other cell have 30/11/2008 and the result should be show in numbers how many
remaining day from today to till last day of give ...

Where will i get task pane option in Excel