|
RE: a interesting question about excel
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.
| 
