Filter and Countifs?

[Limit Braker]

Hi guys,

Im trying to filter to a table some promotions (given that our ERP doesnt have mix and match codes to filter from)

The database im extracting from looks like this:

and the table im filtering it to looks like this:

The colors match the products of the promotion.

So for example.

What if i want to know how many promo2 did store1 sell? witht that given price? (promo2 total price is 25 bucks, how do i sum the values on different rows to add up that criteria and at the same time fulfill all the rest of criterias?)

I did it with Countifs filtering the products from a pivottable so that i can get the total price per ticket.

But can i do it from a formula itself?

Please any suggestions

 

[Limit Braker]

You have error in the Sheet 3. CREATINE MICRONIZED 300 G - DYMATIZE is available in both Goliath 12lb + Creatine 300g & Glutamine 300g + Creatine 300g

oh yes thats an actual promo too. Same product in a different promo