Thursday, June 26, 2014

yogi_Pull Values Into Another Column Value In Cell B3 And Then Every Specified Number Of Rows Below That

                                         Google Spreadsheet   Post  #1681
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-27-2014
post by Aaron Stepanik: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/chrome-browser/no/WH-Z2wZgP_E)
=cell + 7 down
I have a cell in B3 for example, and the next relevant cell is 7 cells down from that, B10. How can I write a formula that would =B3 +7cellsdown?

It would then look like this:

=B3
=B3+7cellsdown
=B10+7cellsdown
=B17+7cellsdown

Thanks.
------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment