Please someone help me to solve this problem. Need a formula to summarized value of specific aged amount

[FMHasan]

New Microsoft Excel Worksheet (2).xlsx
	D	E	F	G	H	I	J	K	L	M	N	O
2							0-30	31-60	61-90	91-120	120-365	366- Avobe
3	Bill No	Bill Date	Aged	Tk			Sum of Tk	Sum of Tk	Sum of Tk	Sum of Tk	Sum of Tk	Sum of Tk
4	100	30-06-22	90	50000
5	101	15-07-22	75	35000
6	102	30-07-22	60	56333
7	103	27-06-22	93	46666
8	104	04-10-22	-6	50004
9	105	05-07-22	85	50005
10	106	06-06-22	114	89745
11	107	26-08-22	33	48000
12	108	08-06-22	112	69315
13	109	25-05-22	126	50009
14	110	06-03-22	206	21365
15	111	31-08-22	28	25464
16	112	12-09-22	16	89750
17	113	01-01-21	635	60000
18	114	01-06-21	484	56000
19	115	01-10-21	362	45680
Pran

Cell Formulas
Range	Formula
F4:F19	F4	=TODAY()-E4-60

 

[Legacy 143009]

Merhaba Hasan,

The formula you are looking for is::
J3 =SUMIFS($G$4:$G$19,$F$4:$F$19,">=0",$F$4:$F$19,"<=30")
And same for K, L, M and N.
O3 =SUMIF($G$4:$G$19,$F$4:$F$19,">=366")

 

[FMHasan]

Merhaba Hasan,

The formula you are looking for is::
J3 =SUMIFS($G$4:$G$19,$F$4:$F$19,">=0",$F$4:$F$19,"<=30")
And same for K, L, M and N.
O3 =SUMIF($G$4:$G$19,$F$4:$F$19,">=366")

Thank you

 

[Peter_SSs]

Another suggestion if you want to make the same formula all the way across.
In my sample, rows 1 & 2 could be hidden if you want.
BTW, I think that you need to change the range in cell N2. Shouldn't that range start from 121 as I have it?

22 11 27.xlsm
	F	G	H	I	J	K	L	M	N	O
1					0	31	61	91	121	366
2					30	60	90	120	365	9.00E+307
3	Aged	Tk			0-30	31-60	61-90	91-120	121-365	366- Avobe
4	90	50000			115214	104333	135005	205726	117054	116000
5	75	35000
6	60	56333
7	93	46666
8	-6	50004
9	85	50005
10	114	89745
11	33	48000
12	112	69315
13	126	50009
14	206	21365
15	28	25464
16	16	89750
17	635	60000
18	484	56000
19	362	45680
Sums

Cell Formulas
Range	Formula
J4:O4	J4	=SUMIFS($G4:$G19,$F4:$F19,">="&J1,$F4:$F19,"<="&J2)

 

[FMHasan]

Another suggestion if you want to make the same formula all the way across.
In my sample, rows 1 & 2 could be hidden if you want.
BTW, I think that you need to change the range in cell N2. Shouldn't that range start from 121 as I have it?

22 11 27.xlsm
	F	G	H	I	J	K	L	M	N	O
1					0	31	61	91	121	366
2					30	60	90	120	365	9.00E+307
3	Aged	Tk			0-30	31-60	61-90	91-120	121-365	366- Avobe
4	90	50000			115214	104333	135005	205726	117054	116000
5	75	35000
6	60	56333
7	93	46666
8	-6	50004
9	85	50005
10	114	89745
11	33	48000
12	112	69315
13	126	50009
14	206	21365
15	28	25464
16	16	89750
17	635	60000
18	484	56000
19	362	45680
Sums

Cell Formulas
Range	Formula
J4:O4	J4	=SUMIFS($G4:$G19,$F4:$F19,">="&J1,$F4:$F19,"<="&J2)

Yes, That should be 121. Thank you.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.