Sum Total
 

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

Sum Total
 

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

Sum Total
 

I would insert a new row 1 (and hide it later). Then I could use an indicator
in each cell in that row that allows me to use =sumif().

If I used X's in row 1, my formula would be:

=sumif($A$1:$DD$1,"x",$a2:$dd2)

Then if I had to insert a new column for any reason, I'd just have to make sure
the indicator cell for that column was ok (x or empty).



Meeru wrote:

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

--

Dave Peterson