Summing certain rows in a for loop

[miam]

Hi,

I have code that loops through several columns and I am trying to add a few rows. For example, I want cell B13 to sum B14-B16; C13 to sum C14-C16, and so on. The code below sums everything. It adds B14, B15, B16, C14, C15, C16 and repeats the same number in row 13. In theory I should have different numbers is B13 and C13. Please help!!

Please Login or Register  to view this content.

[Colin Legg]

Hi and welcome to the forum.

No need for a loop:

Please Login or Register  to view this content.

[miam]

Thank you Colin!

[miam]

Hi Colin, may I ask a follow up question. The code you suggested worked beautifully for my intended purpose so thanks again. I need to repeat the equation again, but this time the variables I am using are in sequential cells, but the output skips a cell. When I use the code below it skips reading the input because the output skips a cell as well.

Please Login or Register  to view this content.

For example, I want to display the results in C57, E57, G57, etc. but the data I'm pulling from is in column B,C,D. I want C57 to use information found in column B; E57 to use info in column C, and so on. Can you please help?

[miam]

Lastly, if its not too much trouble. Could you help me with the syntax for a related If statement.

Please Login or Register  to view this content.

Last question, I promise. I truly appreciate your help!!