Complex autofill,4 rows combine in 1

Hello, I have this formula =IF(ISERROR(MATCH(B11,top5peviso,0)),"0",SUM(Zonas!C8:D11)).
When I drag it down i need next cells to SUM C12:D15, basically I want 4 rows add in 1.
Is it possible to do at all. Also i need to do similar to columns,when i drag right i need next to SUM G8:H11.
But rows are more important to do. IF i will do it manually i will need nearly 3000 formulas in 1 table