Help Needed Pulling Sum Data Across Columns

All,

I'm having a bit of an issue...I need to sum the cells for week week 34 (C:26:G26 & C27:G27) from the daily pass/fail totals and insert that sum into cells C29 & C30 (I've got this part)....I then need to be able to drag this formula across from C29 & C30 to the next column (D29 & D30) for week 35 and have it pull the totals from week 35 (H:26:L26 & H27:L27) and so on. What formula do I need to make this as simple a process as I think it should be?

Any help is appreciated, hopefully my picture is helpful and not too confusing.

8-24-2016 2-30-09 PM.jpg

I presume the other weeks are always 5 days wide (including holidays), so you can put this in C29:

=SUM(INDEX(26:26,(COLUMNS($C:C)-1)*5+3):INDEX(26:26,COLUMNS($C:C)*5+2))

Copy down into C30, then you can copy the two formulae across as far as you need to.

Hope this helps.

Pete

Pete,
YOU'RE THE MAN!!!!! Thanks for the assist, worked as described and as expected. I appreciate it!!

You're welcome - glad to be of help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

For future reference, it is always easier for contributors to work from an Excel file, rather than a picture of one, so you might like to attach a sample workbook to any future threads that you start.

Pete

Thanks for the constructive feedback Pete, it's all been noted. You're help and prompt response allowed me to knock out this job in no time at all!

Chris