Sum with some criteria

[freddocp]

Please, I am having some challenges with a sum with a few criteria, please view the sample attached.

1- I need to sum up the same Part Numbers (column A) I made an example with Descr 2 and Descr 15.

2- Just sum up the different lots (Column B) the lot that has some repeated should not be included in the sum.

3- Status (column C) only consider the terms with ?Demand? in the sum.

In column E: the values I need as a result. For the examples Descr 2 and Descr 15

Note: Remember that you'll need to fill in the whole spreadsheet afterward.

Sum with a few criteria - Rev.0.xlsx
	G
12
Sheet1

Thank you in advance.

 

[freddocp]

I see. Hopefully you could go with something like this (please adjust ranges):

=LET(
a,HSTACK($C$2:$C$5,$F$2:$F$5,$N$2:$N$5,$U$2:$U$5),
f,UNIQUE(FILTER(a,($F$2:$F$5=F2)*($N$2:$N$5="On hand"))),
IF(N2="Supply",0,SUM(CHOOSECOLS(f,4))))

Thank you very much!

 

[hagia_sofia]

You are welcome & thanks for the feedback!

 

[Peter_SSs]

Thank you very much!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

BTW, when using XL2BB you need to first select the range on your worksheet that you want to show before clicking 'Mini Sheet'. In your earlier posts it looks like you just have had a blank cell selected when you clicked the Mini Sheet button