Setting formula to give info from rows with certain criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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) ?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining documents within a master document 3
creating a document from an xl row 1
create a list that places data in 3 colmuns (cells) from mult row/ 1
need help with nested formulas please 3
simple MAX + comparison formula 5
I need a formula to determine the most common data in a row. 1
Excel Help to copy information from one row at a time to another sheet 1
extact certain information from sheet 1 to shhet 2 columns e:e and 2

Back
Top