Sum Product Formula

[Joko Purnomo]

No.	Amount	Pastdue
1	500	2
2	250	8
3	100	15
2	50	25
4	10	25
2	15	5
6	75	3
9	250	11
5	75	30

Criteria	Amount	Detials Formula	Ratio
7+ (1-6)	??	Total amount of 7 up pastdue of the range No. 1 - 6	??	Total amount of 7 up pastdue of the range No. 1 - 6 / Amount of the range No. 1-6

How to sum product formula the table above >

Please help me sir

 

[GraH]

SUMIFS would work too.
Not sure I understand correctly what's meant with 7 up past due

Book1
	C	D	E	F	G	H	I	J	K	L	M
1	No.	Amount	Pastdue				Criteria	Amount	Detials Formula
2	1	500	2				7+ (1-6)	485	Total amount of 7 up pastdue of the range No. 1 - 6
3	2	250	8
4	3	100	15					Ratio
5	2	50	25					45%	Total amount of 7 up pastdue of the range No. 1 - 6 / Amount of the range No. 1-6
6	4	10	25
7	2	15	5
8	6	75	3
9	9	250	11
10	5	75	30
Sheet1

Cell Formulas
Range	Formula
J2	J2	=SUMIFS(D2:D10,C2:C10,"<7",E2:E10,">7")
J5	J5	=J2/SUMIFS(D2:D10,C2:C10,"<7")

 

[Dave Patton]

I am not sure what you are trying to calculate.
Please review the following and provide more information and clarity on what you require.

SumProduct 2022a.xlsm
	A	B	C	D	E
1
2	No.	Amount	Pastdue
3	1	500	2		485
4	2	250	8
5	3	100	15
6	2	50	25
7	4	10	25
8	2	15	5
9	6	75	3
10	9	250	11
11	5	75	30
12
5a

Cell Formulas
Range	Formula
E3	E3	=SUMPRODUCT(--(A3:A11<=7),--(C3:C11>6),B3:B11)