Max SUBTOTALS ARRAY?

[galileogali]

SUMA INTERVALOS SIMULTANEIDAD.xls
	B	C	D	E	F	G	H	I	J	K	L	M	N	O
19	DeclarationofOcupation
20
21			Monthes
22	Cereal	Canthas	Sowing	Harvests	1	1	5	6	7	7	10	12	12	12
23	Wheat	80	1	12	150	150	150	160	275	275	275	195	195	195
24	Rye	70	7	12
25	Barley	45	7	12		275
26	Soybean	70	1	5
27	Corn-Maize	80	6	10
Resumen

It's Possible to obtain the result in "G25" with a Array Formula????


Galileogali

 

[benson26]

Could you please clarify what cell G25 is meant to be showing? Is it the maximum value in Row 24? Or has Row 23 got something to do with it?

Looks like a GCSE question to me!!

 

[galileogali]

benson 26:

G25 = Max of “F23: O23”
“F23: EXTREME O23 " = of Hectares in Each End of Intervals

“F22: O22”: ends of the intervals of each culture

Thanks.

GALI

 

[Domenic]

Try...

=MAX(MMULT(TRANSPOSE(ROW(C23:C27)^0),(SMALL(D23:E27,{1,2,3,4,5,6,7,8,9,10})>=D23:D27)*(SMALL(D23:E27,{1,2,3,4,5,6,7,8,9,10})<=E23:E27)*(C23:C27)))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

 

[galileogali]

Domenic:

Really amazing.
Excellent.

Now, I will begin "to eat" the formula

Thank you, very much.
GALILEOGALI