Adding text

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!!

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!!

Thank you very much. This worked extremely well! Plus it helped making my
charts!

"malik641" wrote:

>
> Try the COUNTIF function. Put your Genres in Column F (cause I'm sure
> they'll repeat NUMEROUS times).Then place the function in column G.
> Example:
>
> F1:Rock-----------G1:=COUNTIF(C:C,$F1)
> F2:Trance
> F3:Alternative
>
> Copy G1 down. This will give you a numeric amount of cells that contain
> each different genre. Hope this is what you were looking for!
>
>
> --
> malik641
>
>
> ------------------------------------------------------------------------
> malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
> View this thread: http://www.excelforum.com/showthread...hreadid=393156
>
>

Thank you I tried but it didn't work!

"Ed Ferrero" wrote:

> 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!!
>
>
>

What does the C:C part mean?

"robert rizzo" wrote:

> Thank you I tried but it didn't work!
>
> "Ed Ferrero" wrote:
>
> > 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!!
> >
> >
> >

Hi robert,

A reference like C:C refers to the whole of column C. So , if you enter the
formula =SUM(C:C) in cell A1, then cell A1 will have the sum of all values
in column C.

Note that if you enter =Sum(C:C) in a cell in column C, you will get a
circular reference.

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

> What does the C:C part mean?
>
> "robert rizzo" wrote:
>
>> Thank you I tried but it didn't work!
>>
>> "Ed Ferrero" wrote:
>>
>> > 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!!
>> >
>> >
>> >

Everything worked. Thanks.!

"malik641" wrote:

>
> The C:C just checks the ENTIRE column of C (which should be your
> genre).
>
> And did it work or not?? which is it? cause it works for me
>
>
> --
> malik641
>
>
> ------------------------------------------------------------------------
> malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
> View this thread: http://www.excelforum.com/showthread...hreadid=393156
>
>