Spreadsheet Update - Collection Tab: Need Cost

Ok, so just like the color and rarity section I removed the Standard Total Count at the bottom, I pull the same data from columns on the Set Tabs, but with this section I needed to add some more collection cells to those Set Tabs.

Cell A65: =SUMIF(X2:X600,"M",AA2:AA600)
Cell A66: =SUMIF(X2:X600,"R",AA2:AA600)
Cell A67: =SUMIF(X2:X600,"U",AA2:AA600)
Cell A68: =SUMIF(X2:X600,"C",AA2:AA600)
Cell A69: =SUMIF(X2:X600,"L",AA2:AA600)
Cell A70: =SUMIF(X2:X600,"T",AA2:AA600)


What this formula does is Looks into Column X from Cell 2 - 600, then it looks for the character defining the rarity (M = Mythic Rare), and will add up the dollar amounts in column AA if they match the search from Column X.

This way, we can look at the rarity column for the cards and do a check in the rarity we are looking for.  If the rarity is found, we can then SUM up the total price for all the cards with the specific rarity from the price column.

With this new Set Tab data collection we can now total it up in the section on the Collection Tab.

Column AA: Mythic Rare
Column AB: Rare
Column AC: Uncommon
Column AD: Common
Column AE: Land
Column AF: Token

Now we will fill the cells with the formulas with the needed Set Tab information.

Column AA: ='Journey Into Nyx'!$A$65
Column AB: ='Journey Into Nyx'!$A$66
Column AC: ='Journey Into Nyx'!$A$67
Column AD: ='Journey Into Nyx'!$A$68
Column AE: ='Journey Into Nyx'!$A$69
Column AF: ='Journey Into Nyx'!$A$70

So now we can gather all the data from the Set Tabs to find how much I would need to fulfil the sets I need.

Legacy Totals
Column AA: =SUM(AA2:AA9)+SUM(AA19:AA26)+SUM(AA36:AA43)+SUM(AA45:AA65)
- This will get applied to each column with the same cells in that column.
- This Cell is right below the complete total cell in Bold Blue.

Modern Totals
Column AA: =SUM(AA10:AA17)+AA23+AA44+SUM(AA66:AA104)
- This will get applied to each column with the same cells in that column.
- This Cell is right below the Legacy total.

There is a Standard total right under the Modern Totals, but I no longer use that total because it just changed too much, and I would fill out my Standard needs pretty quick.