spooferfish Posted February 12, 2012 Share Posted February 12, 2012 Lets see if i can ask this question without confusing you guys in the process.I want to track the % of each rarity of pokemon card from the newest set release. Compare the actual % of each rarity to the % of the rarity I'm getting.Column a is the set number for the cardColumn b is the name of the pokemonColumn c is the rarity of the cardColumn d is the number of that specific card I own The lower table on the right is where I need help. Can I get it to count the number in column d, based on the rarity listed in column c? Or will I have to manually count that each time? (typing this with a sticky shift key, that my son spilled juice in sucked...side question of how to fix that? :P) Link to comment Share on other sites More sharing options...
Guest Rob Posted February 12, 2012 Share Posted February 12, 2012 I'd probably be easiest to first sort them so that you have all of the commons listed first, then all of the uncommon, rares, etc. (There is a way to do this on excel without doing it manually) Then you would add up the number using a SUM command that would be linked to whatever cell you're putting the information in. For example, if cell G16 is where your common card total goes, and your common cards are sorted, you could do something like "SUM(D#:D#)". You can also do it without sorting them, by using an addition command. Click on Cell G16 to edit it, and then click on every cell you wish to add up, separating each one with a plus sign. That way, cell G16 would show your total common card count. I hope that answers your question ^^ Link to comment Share on other sites More sharing options...
spooferfish Posted February 12, 2012 Author Share Posted February 12, 2012 I was hoping to keep the the set number in order, but I may have to do what you suggested if I can't figure something else out.. Link to comment Share on other sites More sharing options...
Randox Posted February 13, 2012 Share Posted February 13, 2012 For the commons it would be (in cell G16): =SUM(D2+D3+D6+D8+D10+D11+D15+D17+D18+D23) You wont need to reorder anything, but you will need to add every relevant cell to the equation manually. Link to comment Share on other sites More sharing options...
spooferfish Posted February 13, 2012 Author Share Posted February 13, 2012 For the commons it would be (in cell G16): =SUM(D2+D3+D6+D8+D10+D11+D15+D17+D18+D23) You wont need to reorder anything, but you will need to add every relevant cell to the equation manually. ....*facedesk*I was way over thinking it. lol, thanks. Link to comment Share on other sites More sharing options...
Markup Posted February 17, 2012 Share Posted February 17, 2012 =sumif(C1:C23, "Common", D1:D23) Link to comment Share on other sites More sharing options...
Sy_Accursed Posted February 22, 2012 Share Posted February 22, 2012 =sumif(C1:C23, "Common", D1:D23) ^this. If functions ftw.This formula will look for any cell in c1:c23 range that says Common (exactly that wording) and add the matching cell from D1:D23 to the sum.So (as it is only set to run to 23) based on screen u shown it would output 6 Operation Gold Sparkles :: Chompy Kills :: Full Profound :: Champions :: Barbarian Notes :: Champions Tackle Box :: MA RewardsDragonkin Journals :: Ports Stories :: Elder Chronicles :: Boss Slayer :: Penance King :: Kal'gerion Titles :: Gold Statue Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now