I
ignatius
try this
use the autofilter to filter your list down to what you
want to see. select the visible cells and use the
count/sum etc facilities in the status bar.
If you need to generate a unique list of artists names etc
I only know of one way which is to create a collection.
you can use this unique list to drive your sum functions.
If you don't know how to code I can send you a quick and
dirty addin that will do it for you.
The other approach is to use array formulas I can send you
some example files/formulas if you think it might work but
they are not for the faint hearted.
use the autofilter to filter your list down to what you
want to see. select the visible cells and use the
count/sum etc facilities in the status bar.
If you need to generate a unique list of artists names etc
I only know of one way which is to create a collection.
you can use this unique list to drive your sum functions.
If you don't know how to code I can send you a quick and
dirty addin that will do it for you.
The other approach is to use array formulas I can send you
some example files/formulas if you think it might work but
they are not for the faint hearted.