Adding text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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!
 
The C:C just checks the ENTIRE column of C (which should be you
genre).

And did it work or not?? which is it? cause it works for me :confused
 
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/
 
Back
Top