These formulas can be copy and pasted into a cell and give you the count for Tier tokens, Armor type, and Role.
They assume that you have not altered your spreadsheet from the default. 
If you have, then you'll need to make changes to the values DCOUNTA( to make them work 

--- E2 where the word "Class" appears
=concat("Protector: ",(DCOUNTA(E2:E1006, 1, {"Class"; "Warrior"; "Hunter"; "Shaman"; "Monk"})-countif(E:E,"Demon Hunter")))
=concat("Conqueror: ",DCOUNTA(E2:E1006, 1, {"Class"; "Paladin"; "Priest"; "Warlock"; "Demon Hunter"}))
=concat("Vanquisher: ",DCOUNTA(E2:E1006, 1, {"Class"; "Rogue"; "Druid"; "Mage"; "DeathKnight"}))

--- E2 where the word "Class" appears
=concat("Cloth: ",DCOUNTA(E2:E1004, 1, {"Class"; "Priest"; "Mage"; "Warlock"}))
=concat("Leather: ",DCOUNTA(E2:E1004, 1, {"Class"; "Rogue"; "Druid"; "Demon Hunter"; "Monk"}))
=concat("Plate: ",DCOUNTA(E2:E1004, 1, {"Class"; "Warrior"; "Paladin"; "Death Knight"}))
=concat("Mail: ",(DCOUNTA(E2:E1006, 1, {"Class"; "Hunter"; "Shaman"})-countif(E:E,"Demon Hunter")))))


---  G2 would be where the word that "Spec" appears
=concat("Tank: ",DCOUNTA(G2:G1006, 1, {"Spec"; "Blood"; "Vengeance"; "Guardian"; "Brewmaster"; "Protection"}))
=concat("Healer: ",DCOUNTA(G2:G1006, 1, {"Spec"; "Restoration"; "Mistweaver"; "Discipline"; "Holy"})-countif(G:G, "Unholy"))
=concat("DPS: ",DCOUNTA(G2:G1006, 1, {"Spec"; "Frost"; "Unholy"; "Havoc"; "Balance"; "Feral"; "Beast Mastery"; "Survival"; "Marksmanship"; "Windwalker"; "Arcane"; "Fire"; "Retribution"; "Shadow"; "Assassination"; "Outlaw"; "Subtlety"; "Elemental"; "Enhancement"; "Affliction"; "Demonology"; "Destruction"; "Arms"; "Fury"}))