sss.jpg
So my goal is to create a formula that will give me the average of "Recent Sale Price of BGS 9.5" excluding blanks and conditioned on "Rarity" and "BGS 9.5 POP".
For example, in my entire data set there are 5 items that have "Rarity"=Rare and "BGS 9.5 POP"=1.
4 of these items have a value for recent sale price, the last does not. I want to average the values that do have a recent sale price.
I'm pretty weak at excel and need some help. I thought I would be able to get the data from pivot tables but i can't seem to get rid of the blank data that is affecting my averages.
Bookmarks