Find profit if criteria exists

[bdenn]

Hello,
I'm looking to find the profit for sales in a list. Problem is I need to check that both the product and size match. When using a sumifs statement, it would not let me set the sum range to a single cell, it only would accept a range.

Goal: If product & size exist/true, then "(Retail Cost - Cost)*Count", but if not skip the equation and check the next possible outcome.

Not sure if sumifs is what I should be using because if the first condition (product & size) don't match then I want it to check the next item to see if it exists.

Thanks,
Bdenn

Profit.xlsx
	A	B	C	D	E	F	G	H	I
1	Sales						Product Cost
2	Count	Retail Cost	Size	Product	Profit		Product	Size	Cost
3	1	20	Size 1	Product 1	$ 12.00		Product 1	Size 1	$ 8.00
4	1	21	Size 2	Product 2	$ 12.00		Product 1	Size 2	$ 9.00
5	1	22	Size 3	Product 3	$ 12.00		Product 1	Size 3	$ 10.00
6							Product 2	Size 1	$ 8.00
7							Product 2	Size 2	$ 9.00
8							Product 2	Size 3	$ 10.00
9	Looking to find the profit under sales (E) Needs to check size and product, if they exist then (B-I)*A (Retail Cost - Cost)*Count						Product 3	Size 1	$ 8.00
10							Product 3	Size 2	$ 9.00
11							Product 3	Size 3	$ 10.00
Sheet1

 

[DanteAmor]

Goal: If product & size exist/true, then "(Retail Cost - Cost)*Count"

How about:

Dante Amor
	A	B	C	D	E	F	G	H	I
1	Sales						Product Cost
2	Count	Retail Cost	Size	Product	Profit		Product	Size	Cost
3	1	20	Size 1	Product 1	12		Product 1	Size 1	8
4	1	21	Size 2	Product 2	12		Product 1	Size 2	9
5	1	22	Size 3	Product 3	12		Product 1	Size 3	10
6							Product 2	Size 1	8
7							Product 2	Size 2	9
8							Product 2	Size 3	10
9	Looking to find the profit under sales (E) Needs to check size and product, if they exist then (B-I)*A (Retail Cost - Cost)*Count						Product 3	Size 1	8
10							Product 3	Size 2	9
11							Product 3	Size 3	10
Hoja4

Cell Formulas
Range	Formula
E3:E5	E3	=B3-(SUMIFS($I$3:$I$11,$G$3:$G$11,D3,$H$3:$H$11,C3))*A3

but if not skip the equation and check the next possible outcome.

I did not understand very well. If it doesn't exist, what do you need?
Could you give a couple of examples

 

[bdenn]

Hello,
I meant that if the input was different it would go down the list till it found it.

Your answer was helpful and worked.

Thank You!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.