Extract Portion of Range / Table from larger table

Hi All!

I am seeking to extract a portion of a table from the larger surrounding table into its own sheet dependent on criteria.

For illustration, imagine a table split into quarters. There are two variables on both the x and y axis of the table; "On" and "Off." On the X axis, the criteria must be "On" and the y axis, the criteria must be "Off." This would return the bottom left quarter of the table which I want to isolate / seperate in its own sheet.

Attachment enclosed.

Thanks in advance!

Originally Posted by CARACALLA

D20=IF(AND($B20<>"",D$19<>""),SUMPRODUCT(($B$4:$B$13=$B20)*($C$4:$C$13=$C20)*($D$2:$M$2=D$18)*($D$3:$M$3=D$19)*($D$4:$M$13)),"")


Copy across and down

(EDIT - Fixed)
My mistake, had some duplicate values hiding in there Original formula works great. Thanks CARACALLA!