Hi,

If you are trying to sum every 4th row then here is one approach:

=SUM(SUM(INDIRECT("F"&ROW(A1:A20)*4)))

This is array entered: This means press Shift+Ctrl+Enter instead of Enter.
This formula adds the items in F4, F8, F12...

Or you can use the non array version:

=SUMPRODUCT(SUM(INDIRECT("F"&ROW(A1:A20)*4)))

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


" wrote:

Hi
How can I use Offset function to copy formulae, in one column and 4
rows, or every 4 rowas
Thnaks in Advance
Jam