My formula is:-  =SUMIF('INPUT PAGE - FLYING TIMES'!$D$4:$D$23,D3,'INPUT
PAGE - FLYING TIMES'!$H$4:$J$23)
D4 to D23 is the part of my data which I'm looking for the answer in D3
(aeroplane type).

Why does Excel's DDB formula never depreciate the whole amount when the
salvage value = 0?  It always leaves a few hundred dollars left to depreciate
-- I've tried tons of examples and they all do this.

I'm having trouble with a "VLOOKUP" formula.
I use Excel to open a text file where the text is separated by spaces.
I go through the motions of establishing what values are to be in what
columns and then click finish.

I am working on a regular excel spreadsheet that I need to print
hundreds of.  However, when i print the spreadsheet, they all need to
be identical with the exception of the page number for reasons of
record.  I would like to have sequential numbering starting at

I've found a solution for the above topic here:
http://groups.google.com/group/microsoft.public.excel.worksheet.functions/browse
_thread/thread/8e30b41766bb7c15/8156eb8a4439d580?lnk=gst&q=duplicate+cell+above+
if+current+cell+is+blank#8156eb8a4439d580
however the instruction on using ...

Any way to edit the font size?

Beginner user in Excel.  I have 2 worksheets, one is detail, the other is
summary for the months.  I am trying to use a formula in the summary
worksheet that will correspond with the detailed one to move the monthly
totals into the summary worksheet.  I don't know how to do this. ...

Is there a way in Excel 2007 to automatically highlight or format all
unprotected cells?

Is there a way to "format" a cell so if i enter a positive value, it converts
to a negative amount? No formulas pleez as I cannot insert a column (it's a
financial thing).

I want to attach an adobe graph to the cell on a way that it will works like
a comment.
Do you know how to do it?
Do you have other option?

I need to sort column B from largest to smallest, but I need the value in
column A that is paired to the value in column B to STAY WITH the value in
column B once it gets sorted.

I am looking for an easy way to compress a large number of data, given
in one long column, into a shorter column that contains the average of
every N cells. Say for instance I have a column with one thousand
numbers, and I want a new column of the one hundred 10-item averages.

is there a way to divide a cell into half so text or color coding can be
applied to the same cell but not have the colors or text overlap?

I have
     A        B        C        D       E       F
1 Name  Value Name  Value Name Value
2    A         6       B        5        B       7

I need to count up the number of occurrences of the letter "Q" in Column A,
only if the string in Column B = "Claims."
That is, how do I combine . . .
=SUMPRODUCT(LEN(A1:A100)-LEN(SUBSTITUTE(A1:A100,"Q","")))