Using either vlookup or IF function

[Balmer07]

Hi,

I have a query.

I have a 2 tables of data, similar to below and basically I need to analyse how many pallets move in and out in a month, the raw data is inputted on the the bottom table but I want to know if there is a way to do a vlookup or IF function to basically add in the total number of pallets on a specific day that have been brought in or sent out against a specific part code.

[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD][/TD]
[TD]Part Code[/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]inbound[/TD]
[/TR]
[TR]
[TD]01/06/2019[/TD]
[TD]**FORMULA NEEDED**[/TD]
[/TR]
[TR]
[TD]02/06/2019[/TD]
[TD]**FORMULA NEEDED**[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Inbound/Outbound[/TD]
[TD]Part Code[/TD]
[TD]Pallet quantity[/TD]
[/TR]
[TR]
[TD]01/06/2019[/TD]
[TD]Inbound[/TD]
[TD]ABC123[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]02/06/2019[/TD]
[TD]Inbound[/TD]
[TD]ABC124[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


If you have any questions to help work it out let me know

thanks,
Steven

 

[Marcelo Branco]

Maybe something like this


[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][/tr]
[tr][td="bgcolor: #DCE6F1"]

1​

[/td][td]

Part Code​

[/td][td]

ABC123​

[/td][td][/td][td]

Date​

[/td][td]

Inbound/Outbound​

[/td][td]

Part Code​

[/td][td]

Pallet quantity​

[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

2​

[/td][td]

Date​

[/td][td]

inbound​

[/td][td][/td][td]

01/06/2019​

[/td][td]

Inbound​

[/td][td]

ABC123​

[/td][td]

2​

[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

3​

[/td][td]

01/06/2019​

[/td][td]

2​

[/td][td][/td][td]

02/06/2019​

[/td][td]

Inbound​

[/td][td]

ABC124​

[/td][td]

4​

[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

4​

[/td][td]

02/06/2019​

[/td][td]

0​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

5​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

Formula in B3 copied down
=SUMIFS(G$2:G$100,$D$2:$D$100,A3,E$2:E$100,B$2,F$2:F$100,B$1)

M.

 

[kurtisw]

Using Marcelo example and your data is formatted as a table the following should work as well.

=SUMIFS(Table1[Pallet Quantity],Table1[Date],A3,Table1[Inbound/Outbound],B2,Table1[Part Code],B1)