Hi again -
Not sure how to title this one but here goes. I have my iTunes library
in excel (cols: Song Name, Artist, Album, etc). I want to count the number of
albums by any given artist. Note that each record is a Song - meaning I have
a row for each song on an album - the artist and album values stay the same
while the Song Name changes. For ex:

Col A ColB ColC
Song 1 Artist Album
Song 2 Artist Album
Song 3 Artist Album

I'd like to have a cell where I can type in a band name and this band name
will be used in another cells' formula to calculate the number of albums I
own by that artist. I know I can use COUNTIF to determine the number of songs
by that artist. Unfortunately, I can't figure out how to count albums.

Any ideas?

Thanks in advance!
meat