You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Igorin" wrote in message
...
It works!!!

Thanks a lot, T.!

--
igor


"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(MOD(COLUMN(G12:BY12)-COLUMN(G12),7)=0),G12:BY12)

Adjust the end of range as needed

--
Biff
Microsoft Excel MVP


"Igorin" wrote in message
...
Hello,

How do I write a function that adds the values for the intersection
between
row 12 and every 7th column (to give a concrete example) .

To illustrate:

Add the cells G12, N12, U12, AB12, ...

Can somebody give me an idea?

--
igor