Sum rows by 3


Board Regular
Nov 19, 2007
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!

Some videos you may like

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.


Well-known Member
Jul 2, 2008
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,"")

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...