Excel 2013 Indirect function. Need Help!

[Terrick]

Hello,

I've fairly "new" to Excel and I'm working for a small company that Interior construction (Division 10) and we have a program that calculates information for us. My question now is, is it possible for Excel to find the "Name" of the item, along with the Quantity(in a different column) and add the Qty totals together in a separate cell/sheet?

I've attached a rough version of what I'm trying to accomplish.
Basically I need Excel to find the name "Towel Bar" in Column A, along with the corresponding Qty in Column B, then add the Qty's together in a separate Cell.

I hope this makes sense, but if it doesnt, please feel free to ask me more questions.

I've tried looking at videos online for several different ways, but haven't been able to come up with much. Ive looked at Indirect, Arrays, Pivot Tables, and a few others. Any Advice is appreciated, or to help point me in the right direction.

Please see attached file!
https://app.box.com/s/k6sfzslcvpt8r8pm05z4g3dr8rdl5q92

Thanks!

 

[Claus8528]

This should do it
=sumif(A:A,"Towel Bar",B:B)

Hope it helps

 

[Terrick]

This should do it
=sumif(A:A,"Towel Bar",B:B)

Hope it helps

That is what I'm looking for! Thank you for your help! How would I go about linking this to a different Sheet?

 

[Claus8528]

Stand in the cell you want the quantity in, type '=sumif(', click on the sheet with the data, click on the column with the names, write '"Towel Bar"', click on the column with the quantities, and type ")".

 

[Claus8528]

Alternatively, just add the name of the sheet with the data and and " ! "in front of A:A and B:B.
=sumif(Datasheet!A:A,"Towel Bar",Datasheet!B:B)

 

[Terrick]

Alternatively, just add the name of the sheet with the data and and " ! "in front of A:A and B:B.
=sumif(Datasheet!A:A,"Towel Bar",Datasheet!B:B)

Again, thank you very much! I had an issue when I tried to link to a sheet called "My Sheet", I had an error of #NAME.
So I renamed the Sheet to Sheet1 and it worked properly. When linking between sheets that have a space in the name, you just link it like "My_Sheet", correct?

EDIT:

=SUMIF('Raw Data'!A:A,"Towel Bar",'Raw Data'!B:B)

I seem to have gotten it working with this. Thanks again!

 

[Terrick]

Again, thank you very much! I had an issue when I tried to link to a sheet called "My Sheet", I had an error of #NAME.
So I renamed the Sheet to Sheet1 and it worked properly. When linking between sheets that have a space in the name, you just link it like "My_Sheet", correct?

EDIT:


I seem to have gotten it working with this. Thanks again!

Double Post, sorry if not allowed.

I have another "in-depth" question and no idea if it's even possible.

Q: Is it possible to do something like this, sumif , but have it only calculate the number from 1 Bedroom? As you can see, there is multiple Unit Styles, so is it possible to pull those numbers for only one unit style and not the others?

Edit: Nevermind, I answered my own question. I changed A:A to A2:A9 and it works.

 

[Claus8528]

You're welcome

Regading the question about sum for a certain unit style:
You could make a column with unit style before the column with Tower bar etc.
Then you could use sumifs (multiple criteria).