Max SUBTOTALS ARRAY?

galileogali

Well-known Member
Joined
Oct 14, 2005
Messages
748
SUMA INTERVALOS SIMULTANEIDAD.xls
BCDEFGHIJKLMNO
19DeclarationofOcupation
20
21Monthes
22CerealCanthasSowingHarvests11567710121212
23Wheat80112150150150160275275275195195195
24Rye70712
25Barley45712275
26Soybean7015
27Corn-Maize80610
Resumen



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


Galileogali
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

benson26

Board Regular
Joined
Mar 16, 2007
Messages
54
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

Well-known Member
Joined
Oct 14, 2005
Messages
748
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

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,406
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

Well-known Member
Joined
Oct 14, 2005
Messages
748
Domenic:

Really amazing.
Excellent.

Now, I will begin "to eat" the formula

Thank you, very much.
GALILEOGALI
 

Watch MrExcel Video

Forum statistics

Threads
1,122,569
Messages
5,596,912
Members
414,110
Latest member
docops

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top