Help with Sum on different columns - Formula and VBA

[markallen71]

Hello,

When I add columns in my sheet using <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>

Say A B C D E F G H I J K L M N O P

In Column P I want to sum G19, J19 and M19

=IF(OR(ISNUMBER(G19), ISNUMBER(J19), ISNUMBER(M19)),SUM(G19,J19,M19),"")

Now when I press my button to enable my <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> macro to run and add a new column by copying G19 and Inserting it into G19 and moving the existing G9 to the right to J19 and the rest move to the right as well.

My sum does not advance like if I had it in a range.

I need the new code to be

=IF(OR(ISNUMBER(G19), ISNUMBER(J19), ISNUMBER(M19), ISNUMBER(P19),SUM(G19,J19,M19,P19),"")

can anyone help with this? <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> or formula that can accomplish this?

Thank you,
Mark

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-...-basic-applications-question-sum-formula.html

Please do not post the same question multiple times. All clarifications, directly-related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).


If you do not receive a response, you can "bump" it by replying to it again, though we advise you not to bump a thread more than once a day.