complex VLOOKUP help please as need to know: how many sales per unique sku?

[big_time_trader]

Hi,

We are using the value "unique sku"

to look up to.

The problem is that each sale is on its own row and we need a total of all sales.

I know what the answers should be, what is the formula? I am very stuck using SUMPRODUCT VLOOKUP.

Does anyone even know how to do this please?!

Thanks,

RP

I am trying to attach the sheet: https://ibb.co/d7kTuo

 

[Legacy 143009]

=sumif($a$2:$a$10,$a16,$c$2:$c$10)

 

[steve the fish]

You need to use SUMIF. The range will be the SKUs. The criteria a single SKU. The sum range the sales.

 

[big_time_trader]

=sumif($a$2:$a$10,$a16,$c$2:$c$10)

=SUMIF(A2:A16,A29,C2:C16) worked for me thanks!

 

[big_time_trader]

You need to use SUMIF. The range will be the SKUs. The criteria a single SKU. The sum range the sales.

Thank you so much Steve! That is so helpful! I used "=SUMIF(A2:A16,A29,C2:C16) worked for me thanks!" and it works.

I will now try this on my live worksheet