I have two seprate but related questions.  I have a few excel workbooks with
multiple worksheets (nearly 30 worksheets in one of them).  Each of the
workbooks has a summary page.  Here are my two SUM related issues:
1) I need to add values in the same cell across the multiple ...

I hope someone can help me here ...
I have a list of names well over 2000 and growing listed in one
column. Adjacent to this column is a list of admission dates and also
a third column of discharge dates.

I have a list of ages of various patients from 18 to 65.
I'm breaking them into age groups and am using SUMPRODUCT.
=SUMPRODUCT((DATA!C2:C2500>=AA16)*(DATA!C2:C2500<=AA34)*(DATA!H2:H2500>=18<20))
C2:C2500 are date fields in format 01-Jan-05.

I am trying to get the row reference from a vlookup not the value.
A: B
Shop : sales
I have repeating records for 100 shops and I am trying to get the row

I've seen it done that a single character was entered into a cell (eg a dash)
and the effect was that the entire cell width was filled with a repetition of
that character. If I widen the cell, more characters appear.
How is this done please?

Thanks Max,
It worked a treat.
How you guys get so good at this stuff just kills me.
Many, many thanks again with my kind regards,

I have a large amount of text in a cell and most of it will wrap, but if the
row height gets to above 200, the text doesn't wrap, display (unless it's
selected), or print.  What's the deal?

I would like to find a way to dynamically sum values in a datagroup so that
if I add or remove items from the the grou the SUM value is updated.
Example:
I create a list of items in a price sheet.

I have a large spreadsheet that I am informed may "fall over" due to the no
of formula's in it - how can I tell when it is getting to the limit of its
maximum no of formula's?

I'm looking for a simple way to calculate the elasped time between two
dates.  I tried the code from the MS site, but felt the result was not
what I was looking for.
I need to see in days/hours elapsed time between two dates.  For

I am trying to match / compare to separate excel columns. My objective is to
find out the silimarities and diferences within the 2 columns, without
distorting the order of one of the columns. Can this be done ?

I am designing a spreadsheet that is comparing values and doing percentages.  
I copy the formula from row 3 all the way down the page and obviously the row
numbers change for each line.  I need to know how to copy and keep certain
portions of the formula from changing and ...

I have multiple sheets with data like that below, my question is, is there a
simple way to to sum all the figures in the different sheets into
consolidated 1 sheet, with the formating remainin the same, without having to
do it cell by cell using the "+" or "=" to link them.

Normally the column is name alphabetically example A, B, C but I dont know
what I did it was changed to numerical 1, 2, 3. How do I change it back to
A,B,C?

I'm trying to use a wild card in the following equation:
=COUNT(IF((B7:B24=$B24)*(I7:I24="C*"),B7:B24))
I tested the same equation with out the wild card by replacing it with the
exact text and it worked fine. What am I doing wrong?