The formula works for me. It gives me the same as =G12+N12+U12+AB12
Perhaps you need to check that you really have numbers in N12, U12, and
AB12, and not text? Make sure that there are no spaces or non-printing
characters. What do =ISNUMBER(N12) and =ISTEXT(N12) give?
--
David Biddulph

"Igorin" wrote in message
...
Thanks for the help, David,

I'm not getting the right amount. It returns the value in the 7th cell but
not the sum of all th cells.


--
igor


"David Biddulph" wrote:

=SUMPRODUCT(G12:AB12,--(MOD(COLUMN(G12:AB12),7)=0))
--
David Biddulph

"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