Take a look at Data|Subtotals (if your data is in sorted order).

Or even Data|Pivottable.

If you want to read more about the pivottable stuff, you may want to look at
some links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistan...lconPT101.aspx

Robert wrote:

Excel 2002. I have a sheet containing 27K rows of data, each row
referenced by a reference number in column A. Many of the rows have
duplicate or triplicate references e.g.
01/010/0002
01/010/0014
01/012/0020
01/012/0020
01/012/0020
01/013/0134
01/014/0004
01/014/0004
but contain different values in subsequent columns.
What I need to do is identify the rows where the references are the same
and sum data in the corresponding rows e.g. for 01/012/0020 above I need
to sum the contents of column C for the 3 related rows and for
01/014/0004 sum the contents of column C for the 2 related rows. I know
how to identify duplicates in column A using =countif(A:A,A1) which will
give me 2 where there is a duplicate entry or 3 where there is a
triplicate entry, but I am not sure where to go from there. I imagine
that I need to extract the data to another range to sum the data in
column C for each reference.
Grateful for any assistance.
--
Robert

--

Dave Peterson