# Sum rows by 3

#### undemane

##### Board Regular
A B C D E F G H I J ..................GW
----------------------------------------------------------------------------
Program BuildDur Hours 1/10 1/17 1/24 1/31 2/7 2/14.................
Prog 1 1 162 0 0 0 0 1 1...........
WkHrs 0 0 0 0 162 162.......
MonthHrs 0 324
Prog 2 1 200 0 0 0 0 1 1...........
WkHrs 0 0 0 0 200 200.......
MonthHrs 0 400
.
.
data ends in row781.
-------------------------------------------------------------------------
The data "Prog1" is in row 212, "Wk Hrs" in row 213, MonthHrs in row 214. "Prog 2" is in row 215, and so on. I want to create a table in another sheet to look like I've shown below:

Program Build Dur Hours Jan-10 Feb-10 Mar-10......................
Prog1 1 162 0 324 0 .......
Prog2 1 162 0 400 0 .......

Is there an easy way to create the table in Sheet2? How do I make the formula in Sheet 2 look at E214, then skip 3 rows to look at Prog 2 in E217 and so on?

Thank you!

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

#### sulakvea

##### Well-known Member
sorry didnt understand 90% of the post, but the 10% that i understood is the part where you wanna look up every 3rd row. you can use =if(mod(row(A1),3)=0,formula if true,"") sort of formula. since you're starting with 214, i would change 0 to 1. so it would be =if(mod(row(A214),3)=0,formula if true,"")

1,106,808
Messages
5,513,517
Members
408,956
Latest member
DianChris