Looking for some help with this, can not seem to get what I am looking for.

[GMCD1972]

Looking for some help with this, can not seem to get what I am looking for. I can not get it to calculate the >=

=SUM(SUMIFS(Inventory[Ext-Value],Inventory[Status],{"0"},Inventory[QOH],">="&Inventory[BSL]))

I'm getting the same total as...

=SUMIFS(Inventory[Ext-Value],Inventory[Status],{"0"})


Example of Table: Inventory[Status] = {"0","NS","AP",DP","RB","RBH","MO"}

Store

Make

Source

Part#

Description

QOH

QPR

BSL

Excess

YRSL

Bin

MNS

MNR

Status

Cost

Ext-Value

MfrDet

Return

LastRC

Min

MFRST

Days

TBSL

Entry

New Source

New Bin

Notes

43831

GM

3

10028352

RETAINER

4

0

0

3

B110G

8

31

NS

$3.75

$15.00

0Y CPOBK

R

11/7/2017

0

5

11/4/2017

5

 

[GMCD1972]

I thought about going that route, just thought throwing all up in a one liner would be much easier,

 

[KRice]

Have a look again at my Result3....I didn't copy your entire table...that's too cumbersome. Here is it with selected columns and your values. You need only the formula associated with Result3.

Book1_20200606.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	Result1	23.5
2	Result2	146.78
3	Result3	13.74
4
5	Store	Make	Source	Part#	Description	QOH	QPR	BSL	Excess	YRSL	Bin	MNS	MNR	Status	Cost	Ext-Value	MfrDet	Return	LastRC	Min	MFRST	Days	TBSL	Entry	New Source	New Bin	Notes
6	43831					4		3						NS		15
7	43831					4		0						NS		100.92
8	43831					16		17						0		9.76
9	43831					2		2						AP		30.38
10	43831					10		2						AP		18.4
11	43831					1		0						AP		134.89
12	43831					1		1						0		13.74
13	43831					1		1						NS		8.37
14	43831					1		1						NS		8.37
Sheet1

Cell Formulas
Range	Formula
B1	B1	=SUMIFS(Inventory[Ext-Value],Inventory[Status],{"0"})
B2	B2	=SUM(SUMIFS(Inventory[Ext-Value],Inventory[Status],{"0"},Inventory[QOH],">="&Inventory[BSL]))
B3	B3	=SUMPRODUCT(Inventory[Ext-Value],(Inventory[Status]=0)*(Inventory[QOH]>=Inventory[BSL]))
Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.

 

[GMCD1972]

After looking at it again your 3rd Formula is correct. I have a error in my table data that is pulling over. Thank you for the help.

 

[KRice]

You're welcome...I'm glad you got things working. My post #5 was intended to demonstrate how multiple rows could have Status=0 and QOH>=BSL, and only rows satisfying both conditions would be summed, so I used arbitrary values.