Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Setting formula to give info from rows with certain criteria
Okie guys,
I was trying to setup my spreadsheet for my collection of magic cards. I have a colmun with card Names, the quantity, and the rarity (common, Uncommon, Rare). Now I can get the thing to tell me how many rows of Common Uncommon and Rare I have, but I need it to sum the quantity of each row of cards that are common..ETC. Example: Blah1 - 23 - Rare Blah2 - 12 - Uncommon Blah3 - 9 - Rare Blah4 - 11 - Common I need it to tell me total of rare cards, but can conly get it to tell me 2 Rares with CountIf. So how do I get it to tell me 32 cards that are rare instead of 2 (based on this example) ? |
#2
|
|||
|
|||
Hi,
Use = SUMIF('CRITERIA RANGE',"Rare",'SUM RANGE') Lets say your data is in the range A1 to C4 (Column B is number of cards and column C is the rarity), then the formula would be =SUMIF(C1:C4,"Rare",B1:B4) Govind. Phish wrote: Okie guys, I was trying to setup my spreadsheet for my collection of magic cards. I have a colmun with card Names, the quantity, and the rarity (common, Uncommon, Rare). Now I can get the thing to tell me how many rows of Common Uncommon and Rare I have, but I need it to sum the quantity of each row of cards that are common..ETC. Example: Blah1 - 23 - Rare Blah2 - 12 - Uncommon Blah3 - 9 - Rare Blah4 - 11 - Common I need it to tell me total of rare cards, but can conly get it to tell me 2 Rares with CountIf. So how do I get it to tell me 32 cards that are rare instead of 2 (based on this example) ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Hiding rows from a formula | Excel Worksheet Functions | |||
Inserting rows and having the formula follow | New Users to Excel | |||
Rearrange info in rows to columns - HELP! | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |