Index, match and sum formula problem with Multiple Criteria

buster01

New Member
Joined
Jan 10, 2014
Messages
13
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.

[TABLE="width: 128"]
<tbody>[TR]
[TD="width: 171, bgcolor: transparent"]
[TABLE="width: 450"]
<tbody>[TR]
[TD="width: 48, bgcolor: transparent"]Row #'s

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

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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...
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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

<tbody> [TD="width: 128, bgcolor: transparent"]
B
[/TD]
[TD="width: 243, bgcolor: transparent"]
C
[/TD]
[TD="width: 144, bgcolor: transparent"]
D
[/TD]
[TD="width: 135, bgcolor: transparent"]
E
[/TD]
[TD="width: 200, bgcolor: transparent"]
F
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 128, bgcolor: transparent"]
Size of Bar
[/TD]
[TD="width: 243, bgcolor: transparent"]
Total # of Sticks Needed
[/TD]
[TD="width: 144, bgcolor: transparent"]
Wt. Per LF
[/TD]
[TD="width: 135, bgcolor: transparent"]
Total Wt.
[/TD]
[TD="width: 200, bgcolor: transparent"]
Total LF Left Over
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 128, bgcolor: transparent"]
3
[/TD]
[TD="width: 243, bgcolor: transparent"]
3
[/TD]
[TD="width: 144, bgcolor: transparent"]
0.376
[/TD]
[TD="width: 135, bgcolor: transparent"]
22.6
[/TD]
[TD="width: 200, bgcolor: transparent"]
0
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 128, bgcolor: transparent"]
4
[/TD]
[TD="width: 243, bgcolor: transparent"]
0
[/TD]
[TD="width: 144, bgcolor: transparent"]
0.668
[/TD]
[TD="width: 135, bgcolor: transparent"]
0
[/TD]
[TD="width: 200, bgcolor: transparent"]
0
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 128, bgcolor: transparent"]
5
[/TD]
[TD="width: 243, bgcolor: transparent"]
5
[/TD]
[TD="width: 144, bgcolor: transparent"]
1.043
[/TD]
[TD="width: 135, bgcolor: transparent"]
104.3
[/TD]
[TD="width: 200, bgcolor: transparent"]
0
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 128, bgcolor: transparent"]
6
[/TD]
[TD="width: 243, bgcolor: transparent"]
0
[/TD]
[TD="width: 144, bgcolor: transparent"]
1.502
[/TD]
[TD="width: 135, bgcolor: transparent"]
0
[/TD]
[TD="width: 200, bgcolor: transparent"]
0
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 128, bgcolor: transparent"]
7
[/TD]
[TD="width: 243, bgcolor: transparent"]
0
[/TD]
[TD="width: 144, bgcolor: transparent"]
2.044
[/TD]
[TD="width: 135, bgcolor: transparent"]
0
[/TD]
[TD="width: 200, bgcolor: transparent"]
0
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 128, bgcolor: transparent"]
8
[/TD]
[TD="width: 243, bgcolor: transparent"]
0
[/TD]
[TD="width: 144, bgcolor: transparent"]
2.670
[/TD]
[TD="width: 135, bgcolor: transparent"]
0
[/TD]
[TD="width: 200, bgcolor: transparent"]
0
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 128, bgcolor: transparent"]
9
[/TD]
[TD="width: 243, bgcolor: transparent"]
0
[/TD]
[TD="width: 144, bgcolor: transparent"]
3.400
[/TD]
[TD="width: 135, bgcolor: transparent"]
0
[/TD]
[TD="width: 200, bgcolor: transparent"]
0
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 128, bgcolor: transparent"]
10
[/TD]
[TD="width: 243, bgcolor: transparent"]
0
[/TD]
[TD="width: 144, bgcolor: transparent"]
4.303
[/TD]
[TD="width: 135, bgcolor: transparent"]
0
[/TD]
[TD="width: 200, bgcolor: transparent"]
0
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 128, bgcolor: transparent"]
11
[/TD]
[TD="width: 243, bgcolor: transparent"]
0
[/TD]
[TD="width: 144, bgcolor: transparent"]
5.313
[/TD]
[TD="width: 135, bgcolor: transparent"]
0
[/TD]
[TD="width: 200, bgcolor: transparent"]
0
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
</tbody>


 
Upvote 0

Forum statistics

Threads
1,223,909
Messages
6,175,315
Members
452,634
Latest member
cpostell

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

Which adblocker are you using?

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
Back
Top