J

#### JJ

I have tried everything I can think of but with no luck - can somebody

please help.

On sheet 2 I have all the data in columns from rows 1-20.

On sheet 1 I want the total of the sums of every 3rd column.

ie. Sheet 1: A1 = sum Sheet 2: A1:A20

Sheet 1: B1 = sum Sheet 2: D120

Sheet 1: C1 = sum Sheet 2: G1:G20 and so on...

Instead of manually entering all the formulas on Sheet 1 for the sum totals

of every 3rd column, is there a formula I can enter in A1 on Sheet 1 and copy

across the row?

Thanks for any help!!