Index, match and sum formula problem with Multiple Criteria

[buster01]

I am new to Mr. Excel I look at it often for answers to questions about formulas that I have. Most of the time I can research it out enough to figure out and find a formula that works. I don't like to bother people if I can do it myself. But I just can't figure this out. please help. If I have done this wrong please forgive me.
I need a formula that will return the (Total # of Sticks Needed) in C34:C42 by looking in E12:E30, and matching the size of bar in B34:42 and summing the total, and returning it in C34:C42.
In C48:C50 is what I am trying to accomplish.

Row #'s Excel 2010 (Windows) 64 bit A B C D E F 12 Size of Continious Bar 5 # 13 Total # of Sticks Needed 19 EA 14 Total LF Left Over For Continous Ftg. Bar 17.34 LF 15 16 Size Of Transverse Bar 3 # 17 Total # of Sticks Needed 5 EA 18 Total LF Left Over For Transverse Ftg. Bar 17.50 LF 19 20 Size of Corner Bar 4 # 21 Total # of Sticks Needed 3 EA 22 Total LF Left Over For Corner Ftg. Bar 10.08 LF 23 24 Size of Tee Bar 5 # 25 Total # of Sticks Needed 2 EA 26 Total LF Left Over For Tee Bar 15.04 LF 27 28 Size of Step Bar 4 # 29 Total # of Sticks Needed 2 EA 30 Total LF Left Over For Bent Step Bar 9.04 LF 31 32 Totals 33 Size of Bar Total # of Sticks Needed Wt Per LF Total Wt. Total LF Left Over 34 3 0.376 0.000 0.00 35 4 0.668 0.000 0.00 36 5 1.043 0.000 0.00 37 6 1.502 0.000 0.00 38 7 2.044 0.000 0.00 39 8 2.670 0.000 0.00 40 9 3.400 0.000 0.00 41 10 4.303 0.000 0.00 42 11 5.313 0.000 0.00 43 Subtotal 0.00 0.00 44 Totals 0 0 45 46 47 Size of Bar Total # of Sticks Needed Wt Per LF Total Wt. Total LF Left Over 48 3 5 0.376 37.600 17.50 49 4 5 0.668 66.800 19.12 50 5 21 1.043 438.060 32.38 51 6 1.502 0.000 0.00 52 7 2.044 0.000 0.00 53 8 2.670 0.000 0.00 54 9 3.400 0.000 0.00 55 10 4.303 0.000 0.00 56 11 5.313 0.000 0.00 57 Subtotal 542.46 69.00 58 Totals 543 69 <tbody> </tbody>

<tbody>
</tbody>

 

[Chrisdontm]

Try this;

In Cell: C34
=SUMIFS($E$13:$E$31,$D$13:$D$31,$C$33,$E$12:$E$30,$B34)
And copy it on down...

In Cell: E34
=ROUND($C34*20*$D34,1)
And copy it on down...

In Cell: F34
=SUMIFS($E$14:$E$32,$D$13:$D$31,$C$33,$E$12:$E$30,$B34)
And copy it on down...

 

[buster01]

Thank you so much Chrisdontm for you response. I copied the formula over, but it returned all zero's. I may have done some think wrong?? But that is better than what I have been getting. I have gotten it to return some #'s but the totals are wrong. I just can't figure out what I am missing...
Thanks again for your response.

 

[Chrisdontm]

I forgot to mention one thing...

In the formula it is looking for the phrase: " Total # of Sticks Needed "

When I copied your sheet they didn't match, I don't know why not...

So try this;

In your sheet, copy cell: D13 and paste it down in cell: C33

In the formula it is looking for those two cells to be exactly the same.
They looked the same, but there was something different about them.

 

[buster01]

This is what it returned, I am not sure how it came up withthis, but with your help I am getting closer at least I am getting numbersinstead of all zeros. Thanks

B​	C​	D​	E​	F​
Size of Bar​	Total # of Sticks Needed​	Wt. Per LF​	Total Wt.​	Total LF Left Over​
3​	3​	0.376​	22.6​	0​
4​	0​	0.668​	0​	0​
5​	5​	1.043​	104.3​	0​
6​	0​	1.502​	0​	0​
7​	0​	2.044​	0​	0​
8​	0​	2.670​	0​	0​
9​	0​	3.400​	0​	0​
10​	0​	4.303​	0​	0​
11​	0​	5.313​	0​	0​

<tbody> </tbody>