Complex autofill,4 rows combine in 1

[irisis]

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

[Pete_UK]

Yes, it can be done, but you will need to change your title to something more descriptive of your problem before any help can be given - see the Forum Rules at the top of the screen.

Pete

[Pete_UK]

I've only just noticed that you have changed your title (I expected you to post to say that you had done that, and I would have received a notification).

Anyway, put this formula in the cell where you want to reference the cells C8:D11:

=IF(ISERROR(MATCH(B11,top5peviso,0)),"0",SUM(INDIRECT("'Zonas'!C"&ROWS($1:1)*4+4&":D"&ROWS($1:1)*4+7))).

When you copy it into the next row the part within the INDIRECT function will become ROWS($1:2)*4+4, which evaluates to 12 so you will reference C12:D15, then C16:D19 etc on subsequent rows.

It is more difficult to do this for copying across columns because of the letter identifiers, and the fact that it quickly becomes two letters.

Hope this helps.

Pete

[irisis]

Formula works fine.Great job.
Thanks for your help, Pete!