Try this...

=SUMPRODUCT(--(MOD(COLUMN(A1:DD1)-COLUMN(A1),3)=0),A1:DD1)

--
Biff
Microsoft Excel MVP


"Meeru" wrote in message
...
I would like to total numbers on every 4th column starting from Column A to
Column DD.

Column
A B C D E F G H I J K L M N ........... DD
2 1 3 4 bo 3 5 10 34 =sum(

how can i make a sum total without making a formulas like this =
sum(A1,D1,G1,J1,M1.......)
I would like to find a quick way.

many thanks
meeru