# Excel 2013 Indirect function. Need Help!

#### Terrick

##### New Member
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!

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
This should do it
=sumif(A:A,"Towel Bar",B:B)

Hope it helps

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?

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 ")".

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)

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!

Last edited:
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.

Last edited:
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).

Replies
2
Views
336
Replies
3
Views
132
Replies
2
Views
400
Replies
9
Views
352
Replies
0
Views
888

Threads
1,203,558
Messages
6,056,078
Members
444,844
Latest member
Taps07

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back