Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula needed for adding every nth column on another sheet
Hi
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: D1:D20 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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet name needed for formula | Excel Worksheet Functions | |||
formula needed to bring values to another sheet | Excel Worksheet Functions | |||
Adding a Comment-Column to an external data-sheet | Excel Worksheet Functions | |||
Compare one Column to a Second Column Formula Help Needed | Excel Worksheet Functions | |||
Adding Column in an Excel Sheet by Command | Excel Worksheet Functions |