summarize a range

  • Thread starter Thread starter Jim L
  • Start date Start date
J

Jim L

I have an Excel estimate sheet with a list of code numbers
in column A, plus 28 other columns (some are text and some
calculations) per row. Some code numbers in column A
appear once, some as many as 15 times consecutively, but
always together. What I'm trying to do is summarize
the "total" figures at the end of each row, so that the
totals of rows with identical code numbers are summed. The
sheet has as many as 175 rows. Can anyone think of a way
to, say, add another sheet to the workbook that contains
only the summed amounts?
For example, row 20 has code number 305, which is the only
row with that code number. Row 26 has code number 320, the
same code number as rows 27 through 33. All rows present a
total in their right-most column. I want a sheet that
contains one row for the total of row 20, and one row that
contains the sum of rows 26 through 33. Actual row
numbers, and the quantity of rows with identical code
numbers, varies from one estimate to another.
Any ideas? Thanks.
 
Jim,
They can be a little difficult to learn, but Pivot Tables are very powerful and probably just what you need.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Jim L wrote: -----

I have an Excel estimate sheet with a list of code numbers
in column A, plus 28 other columns (some are text and some
calculations) per row. Some code numbers in column A
appear once, some as many as 15 times consecutively, but
always together. What I'm trying to do is summarize
the "total" figures at the end of each row, so that the
totals of rows with identical code numbers are summed. The
sheet has as many as 175 rows. Can anyone think of a way
to, say, add another sheet to the workbook that contains
only the summed amounts?
For example, row 20 has code number 305, which is the only
row with that code number. Row 26 has code number 320, the
same code number as rows 27 through 33. All rows present a
total in their right-most column. I want a sheet that
contains one row for the total of row 20, and one row that
contains the sum of rows 26 through 33. Actual row
numbers, and the quantity of rows with identical code
numbers, varies from one estimate to another.
Any ideas? Thanks.
 
Back
Top