Vlookup & sum of multiple sales in various columns

P

peterECD

New Member
Joined
Jun 6, 2016
Messages
8
Hi,
Need a solution for the following please;
1. Search a product from a product list a-z in a product tab
2. Find all sales for this product in the Sales Tab in the same sheet.
3. Sales for products have multiple entries (quantities) in columns E, H, K, N, Q...etc every 3rd column.
4 Add all sales by product and return a total next to the product in the product tab.

Ive tried SUMIF and sum(VLOOKUP) but cant get a solution.

Hoep someone can assist please!
Thanks
Peter
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Sort by date Sort by votes
"Sales for products have multiple entries (quantities) in columns E, H, K, N, Q...etc every 3rd column."
So sales for a product go horizontally.

Can a product code appear more than once in the Sales tab, e.g.

Code: 
                   Sales
Shirts             3     11     12     9
Trousers           2     14
Shirts             6     5
 
Last edited:
Upvote 0
Hi,
Yes it can. The product appears in multiple columns eg Columns 1(C),4(F),7(I),10(L),13(O) etc and the quantity associated with that product is in columns 3(E), 6(H), 9(K), 12(N), Q...etc every 3rd column.

For example;
Shirts 3 Trousers 12 Shirts 9
Trousers 2 Shirts 14 Belts 8
Shirts 6 Belts 5
Belts 4

Show Total sales on the Product tab;
Shirts 32
Trousers 14
Belts 17
etc
Thanks hope this is clearer.
 
Upvote 0
Not sure I have the concept and it doesn't sound like SUMIF or VLOOKUP are the tools for the job.

Try in B2 and filled down
Code: 
=SUM(INDEX($C$2:$O$11,,MATCH($A2,$C$1:$O$1,0)))
Can you adapt this to your tabs?



[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]
A​
[/td][td="bgcolor: #DCE6F1"]
B​
[/td][td="bgcolor: #DCE6F1"]
C​
[/td][td="bgcolor: #DCE6F1"]
D​
[/td][td="bgcolor: #DCE6F1"]
E​
[/td][td="bgcolor: #DCE6F1"]
F​
[/td][td="bgcolor: #DCE6F1"]
G​
[/td][td="bgcolor: #DCE6F1"]
H​
[/td][td="bgcolor: #DCE6F1"]
I​
[/td][td="bgcolor: #DCE6F1"]
J​
[/td][td="bgcolor: #DCE6F1"]
K​
[/td][td="bgcolor: #DCE6F1"]
L​
[/td][td="bgcolor: #DCE6F1"]
M​
[/td][td="bgcolor: #DCE6F1"]
N​
[/td][td="bgcolor: #DCE6F1"]
O​
[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]
1​
[/td][td][/td][td][/td][td]
Shirts​
[/td][td][/td][td][/td][td]
Trousers​
[/td][td][/td][td][/td][td]
Belts​
[/td][td][/td][td][/td][td]
Shoes​
[/td][td][/td][td][/td][td]
Hats​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
2​
[/td][td="bgcolor:#FFFF00"]
Shirts​
[/td][td]
77​
[/td][td="bgcolor:#FFFF00"]
6​
[/td][td][/td][td][/td][td="bgcolor:#B4C6E7"]
6​
[/td][td][/td][td][/td][td="bgcolor:#C6E0B4"]
7​
[/td][td][/td][td][/td][td="bgcolor:#FFD966"]
10​
[/td][td][/td][td][/td][td="bgcolor:#AEAAAA"]
6​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
3​
[/td][td="bgcolor:#B4C6E7"]
Trousers​
[/td][td]
61​
[/td][td="bgcolor:#FFFF00"]
11​
[/td][td][/td][td][/td][td="bgcolor:#B4C6E7"]
13​
[/td][td][/td][td][/td][td="bgcolor:#C6E0B4"]
10​
[/td][td][/td][td][/td][td="bgcolor:#FFD966"]
11​
[/td][td][/td][td][/td][td="bgcolor:#AEAAAA"]
6​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
4​
[/td][td="bgcolor:#C6E0B4"]
Belts​
[/td][td]
87​
[/td][td="bgcolor:#FFFF00"]
7​
[/td][td][/td][td][/td][td="bgcolor:#B4C6E7"]
3​
[/td][td][/td][td][/td][td="bgcolor:#C6E0B4"]
8​
[/td][td][/td][td][/td][td="bgcolor:#FFD966"]
5​
[/td][td][/td][td][/td][td="bgcolor:#AEAAAA"]
0​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
5​
[/td][td="bgcolor:#FFD966"]
Shoes​
[/td][td]
92​
[/td][td="bgcolor:#FFFF00"]
12​
[/td][td][/td][td][/td][td="bgcolor:#B4C6E7"]
0​
[/td][td][/td][td][/td][td="bgcolor:#C6E0B4"]
14​
[/td][td][/td][td][/td][td="bgcolor:#FFD966"]
10​
[/td][td][/td][td][/td][td="bgcolor:#AEAAAA"]
1​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
6​
[/td][td="bgcolor:#AEAAAA"]
Hats​
[/td][td]
48​
[/td][td="bgcolor:#FFFF00"]
8​
[/td][td][/td][td][/td][td="bgcolor:#B4C6E7"]
10​
[/td][td][/td][td][/td][td="bgcolor:#C6E0B4"]
13​
[/td][td][/td][td][/td][td="bgcolor:#FFD966"]
11​
[/td][td][/td][td][/td][td="bgcolor:#AEAAAA"]
3​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
7​
[/td][td][/td][td][/td][td="bgcolor:#FFFF00"]
9​
[/td][td][/td][td][/td][td="bgcolor:#B4C6E7"]
0​
[/td][td][/td][td][/td][td="bgcolor:#C6E0B4"]
5​
[/td][td][/td][td][/td][td="bgcolor:#FFD966"]
7​
[/td][td][/td][td][/td][td="bgcolor:#AEAAAA"]
9​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
8​
[/td][td][/td][td][/td][td="bgcolor:#FFFF00"]
0​
[/td][td][/td][td][/td][td="bgcolor:#B4C6E7"]
9​
[/td][td][/td][td][/td][td="bgcolor:#C6E0B4"]
9​
[/td][td][/td][td][/td][td="bgcolor:#FFD966"]
13​
[/td][td][/td][td][/td][td="bgcolor:#AEAAAA"]
6​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
9​
[/td][td][/td][td][/td][td="bgcolor:#FFFF00"]
11​
[/td][td][/td][td][/td][td="bgcolor:#B4C6E7"]
7​
[/td][td][/td][td][/td][td="bgcolor:#C6E0B4"]
9​
[/td][td][/td][td][/td][td="bgcolor:#FFD966"]
8​
[/td][td][/td][td][/td][td="bgcolor:#AEAAAA"]
0​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
10​
[/td][td][/td][td][/td][td="bgcolor:#FFFF00"]
13​
[/td][td][/td][td][/td][td="bgcolor:#B4C6E7"]
7​
[/td][td][/td][td][/td][td="bgcolor:#C6E0B4"]
6​
[/td][td][/td][td][/td][td="bgcolor:#FFD966"]
6​
[/td][td][/td][td][/td][td="bgcolor:#AEAAAA"]
9​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
11​
[/td][td][/td][td][/td][td="bgcolor:#FFFF00"]
0​
[/td][td][/td][td][/td][td="bgcolor:#B4C6E7"]
6​
[/td][td][/td][td][/td][td="bgcolor:#C6E0B4"]
6​
[/td][td][/td][td][/td][td="bgcolor:#FFD966"]
11​
[/td][td][/td][td][/td][td="bgcolor:#AEAAAA"]
8​
[/td][/tr]
[/table]
 
Last edited:
Upvote 0
Hi
Ive worked how how to insert my files'
Heres the Product Tab;
Excel 2010
AB
ItemsQTY
144XT
145SJ
145SS
14DI
14JF
14RS
14SE
14SI2
14SW1
14SWD
14SWE
14SWS
151PJ
151PM
151PS
151SJR
151SS
151SS3
151SS4
151SS5

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"][/TD]

</tbody>
Items​



Heres is the SAles Tab;
Item1, Item 2 etc are the products, Total per Kit 1 are the sales by item;
Excel 2010
ABCDEFGHIJKLMN
Qty InvoicedKit Reporting CodeItem 1QtyTotal per Kit 1Item 2QtyTotal per Kit 2Item 3QtyTotal per Kit 3Item 4QtyTotal per Kit 4
24VB10k 24VB
24VF10k 24VF
24VG10k 24VG
24VO10k 24VO
24VR10k 24VR
24VRGY10k 24VRGY
24VRGYS10k 24VRGYS
24VRRB10k 24VRRB
24VRRBS10k 24VRRBS
24VY10k 24VY
43AHBk 40AR40AY401A
43BB3k 181N364MS
43BB5k 181N564MS
43BB5Ck 181N5C64MS
43BB6k 181N664MJ
43BB6Ck 181N6C64MJ
43BB7k 181N764MJ
43BB7Ck 181N7C64MJ
43BBLk 28BBC28BBL28BBN28BBN11

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]11[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]66[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]66[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]12[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]120[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]32[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]320[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]13[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]130[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]7[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]70[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]40[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]40[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]11[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]11[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]11[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]11[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]11[/TD]

</tbody>
Kits Invoiced​
Hope this makes more sense mow.
 
Upvote 0
No I am not making sense of this. I am not seeing the connections between the Product tab and sales tab. I see nothing in common between the 2 ... no items match.
 
Last edited:
Upvote 0
Sorry, hope I can define this better;
The product tab is the summary of sales by product in the full spreadsheet on Sales Tab(kits invoiced);
Here is a grab of the product list from the product tab, for example 64MS is shown in the sales spreadsheet in row F, but could also be anywhere in the sheet. So the formula needs to search for every entry which may exist in this sales tab and total the qty sold.
Excel 2010
A
64CBT
64CBTL
64CBTX
64FBC
64HC
64MJ
64MS
64MSS
64SL
64SS
65A
65AD
66KB
671B
673B
673C
691YB
691YG
691YR

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]210[/TD]

[TD="align: center"]211[/TD]

[TD="align: center"]212[/TD]

[TD="align: center"]213[/TD]

[TD="align: center"]214[/TD]

[TD="align: center"]215[/TD]

[TD="align: center"]216[/TD]

[TD="align: center"]217[/TD]

[TD="align: center"]218[/TD]

[TD="align: center"]219[/TD]

[TD="align: center"]220[/TD]

[TD="align: center"]221[/TD]

[TD="align: center"]222[/TD]

[TD="align: center"]223[/TD]

[TD="align: center"]224[/TD]

[TD="align: center"]225[/TD]

[TD="align: center"]226[/TD]

[TD="align: center"]227[/TD]

[TD="align: center"]228[/TD]

</tbody>
Items​
 
Upvote 0
Referencing the Sales tab posted in Post #5 and using the most recent Product list Post #7


[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]
Q​
[/td][td="bgcolor: #DCE6F1"]
R​
[/td][td="bgcolor: #DCE6F1"]
S​
[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]
1​
[/td][td="bgcolor:#FFFF00"]
Product​
[/td][td]
Sums​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
2​
[/td][td="bgcolor:#FFFF00"]
64CBT​
[/td][td]
0​
[/td][td]
In R2: =SUMIF($C$2:$L$20,Q2,$E$2:$N$20)​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
3​
[/td][td="bgcolor:#FFFF00"]
64CBTL​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
4​
[/td][td="bgcolor:#FFFF00"]
64CBTX​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
5​
[/td][td="bgcolor:#FFFF00"]
64FBC​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
6​
[/td][td="bgcolor:#FFFF00"]
64HC​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
7​
[/td][td="bgcolor:#FFFF00"]
64MJ​
[/td][td]
16​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
8​
[/td][td="bgcolor:#FFFF00"]
64MS​
[/td][td]
57​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
9​
[/td][td="bgcolor:#FFFF00"]
64MSS​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
10​
[/td][td="bgcolor:#FFFF00"]
64SL​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
11​
[/td][td="bgcolor:#FFFF00"]
64SS​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
12​
[/td][td="bgcolor:#FFFF00"]
65A​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
13​
[/td][td="bgcolor:#FFFF00"]
65AD​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
14​
[/td][td="bgcolor:#FFFF00"]
66KB​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
15​
[/td][td="bgcolor:#FFFF00"]
671B​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
16​
[/td][td="bgcolor:#FFFF00"]
673B​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
17​
[/td][td="bgcolor:#FFFF00"]
673C​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
18​
[/td][td="bgcolor:#FFFF00"]
691YB​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
19​
[/td][td="bgcolor:#FFFF00"]
691YG​
[/td][td]
0​
[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
20​
[/td][td="bgcolor:#FFFF00"]
691YR​
[/td][td]
0​
[/td][td][/td][/tr]
[/table]
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Populating, aggregating and sorting multiple matching values in Excel
Replies
0
Views
220
Pbobas
P
A
  • Question Question
Master pivot table with multiple smaller pivot tables
Replies
3
Views
2K
rcgyuk
R
A
  • Question Question
Xlookup, Vlookup and/or VBA for finding, matching and inputting data to separate sheet
Replies
0
Views
848
AlfredDB
A
S
  • Solved
Mix of info in a column that needs to be specific in a given month, but matches the final criteria for a total.
Replies
4
Views
58
Fluff
Fluff
E
  • Question Question
Vlookup with Multiple Matches in one column.
Replies
2
Views
307
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,823
Messages
6,181,176
Members
453,021
Latest member
Justyna P

Share this page

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