Sum Total

M

Meeru

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
 
D

Dave Peterson

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top