Shoutbox

quote:

---

Originally posted by Adeptus
There is more than one way to do anything and it also depends on how your spreadsheet is organized, which you don't explain very well.

What would make sense to me (perhaps because I deal with databases a lot) would be one list, with a column for genre.  In that case, you can count the number of entries for each genre using =COUNTIFF(range, value) function on that column.

For a split list (for example, if you use different worksheet for each genre), you can use =COUNTA(range) function on any column that will be non-blank, such as title.

If neither of these fits your situation, please explain how your spreadsheet is organized.

---

this is how my lists are setup: i have 5 lists

1) albums on various dvd's
2) burnt albums
3) bought albums
4) albums on portable harddrive
5) albums on computer