Hi robert,

Either:
1) Use Sort (from the Data menu) to sort by genre, then use Subtotal (again
from the Data menu).
or
2) Build a pivot table. You can access a tutorial on pivot tables at
http://edferrero.m6.net/Pivot200301.shtml

Ed Ferrero
http://edferrero.m6.net/


I have a spreadsheet of my 550+ CD collection. What i'm trying to do is sum
up each genre. I have twenty different genres (folk, blues, classic rock,
rap, etc...) and what I want to do is find the total for each. As of now I
have 4columns. In A is the Artist; B-album title; C-genre; D-total for
each
section(D cells are empty up to the last row in each section where the
total
for that section is). My collection is broken up in Alphabetic order by
Artist. There is a title row above each section with the letter of the
alphabet pertaining to the text below. I'm also trying to find a way to
create charts showing the percentages for each genre as well, but am
having
no luck. Please help!!