increase Range Sumifs Formula

[howard]

I have the following SUMIFS formula

=SUMIFS(B5:B23,A5:A23,({"60-90","120+"}))

I would like to increase the range to the last column before where "Grand Total" appears


The ageing (Criteria is in Col A)


I am trying to sum all the values in Col B to the col before Grand Total (last Col) where the criteria is "60-90" & "120+"


It would be appreciated if someone could assist me in resolving this

 

[Weazel]

maybe something like...

=SUM(SUMIFS(B5:B23,A5:A23,{"60-90";"120+"}))

 

[howard]

Thanks for your help. I need to sum the data for all the columns except the last column containing text "Grand Total"


See Sample Data below


Kindly amend formula

Book1
	A	B	C	D	E	F	G	H	I
2	Ageing	BR1	BR2	BR3	BR4	BR5	BR6	BR7	Grand Total
3	<30 or (blank)		57.00	186.73	124.49	188.54			556.76
4	30-60	206.40		233.37	16.07		16.07		471.92
5	60-90	230.49			38.70		15.38	60.80	345.37
6	Grand Total	436.89	57.00	420.10	179.27	188.54	31.45	60.80	1,374.05
7
Sheet1

 

[howard]

I have attempted to add the value in the column pertaining to Grand Total for criteria 60-90,90-120


It would be appreciated if someone could correct this

Book1
	A	B	C	D	E	F	G	H	I
1	Debtors > 90 Days	#VALUE!
2	Ageing	BR1	BR2	BR3	BR4	BR5	BR6	BR7	Grand Total
3	<30 or (blank)		57.00	186.73	124.49	188.54			556.76
4	30-60	206.40		233.37	16.07		16.07		471.92
5	60-90	230.49			38.70		15.38	60.80	345.37
6	Grand Total	436.89	57.00	420.10	179.27	188.54	31.45	60.80	1,374.05
7
8
9
10
11
Sheet1

Cell Formulas
Range	Formula
B1	=SUM(SUMIFS(I4:I26,A4:A26,({"60-90","120-150"}),A4:S4,"Grand Total"))