how do you total columns that are not adjacent
 

how do you total columns that are not adjacent but in the same row?

I saw this previous post but cannot figure it out:

"I want to add up, the first is at G4, the next is N4, then U4 etc etc...
until the last cell is BCZ4. So, every interval space of 6 cells. The values
are all in the same row.

reply: Try this

=SUMPRODUCT((MOD((COLUMN(G4:BCZ4)-COLUMN($F$4)),7)=1)*(G4:BCZ4))"

I would like to: begin with the amount in D7
subtract amount in E7
add amount in H7
provide answer in I7

is this possible? if so, how?

really appreciate your help...will be a very long
spreadsheet and these calculations will be beneficial.

thank you!




EggHeadCafe - Software Developer Portal of Choice
Transparent NTLM Authentication With ADSI and ASP
http://www.eggheadcafe.com/tutorials...-authenti.aspx

how do you total columns that are not adjacent
 

Maybe?

=SUMPRODUCT((MOD((COLUMN(G4:BCZ4),7)=1)*(G4:BCZ4))-e7+h7

--
Don Guillett
Microsoft MVP Excel
SalesAid Software


"Lyn Kolf" wrote in message ...
how do you total columns that are not adjacent but in the same row?

I saw this previous post but cannot figure it out:

"I want to add up, the first is at G4, the next is N4, then U4 etc etc...
until the last cell is BCZ4. So, every interval space of 6 cells. The
values
are all in the same row.

reply: Try this

=SUMPRODUCT((MOD((COLUMN(G4:BCZ4)-COLUMN($F$4)),7)=1)*(G4:BCZ4))"

I would like to: begin with the amount in D7
subtract amount in E7
add amount in H7
provide answer in I7

is this possible? if so, how?

really appreciate your help...will be a very long
spreadsheet and these calculations will be beneficial.

thank you!




EggHeadCafe - Software Developer Portal of Choice
Transparent NTLM Authentication With ADSI and ASP
http://www.eggheadcafe.com/tutorials...-authenti.aspx

how do you total columns that are not adjacent
 

Hi,

I don't understand which is the question.

Is it this

=SUM(IF(MOD(COLUMN(G4:BCZ4),7)=0,G4:BCZ4))

or something else

Mike

"Lyn Kolf" wrote:

how do you total columns that are not adjacent but in the same row?

I saw this previous post but cannot figure it out:

"I want to add up, the first is at G4, the next is N4, then U4 etc etc...
until the last cell is BCZ4. So, every interval space of 6 cells. The values
are all in the same row.

reply: Try this

=SUMPRODUCT((MOD((COLUMN(G4:BCZ4)-COLUMN($F$4)),7)=1)*(G4:BCZ4))"

I would like to: begin with the amount in D7
subtract amount in E7
add amount in H7
provide answer in I7

is this possible? if so, how?

really appreciate your help...will be a very long
spreadsheet and these calculations will be beneficial.

thank you!




EggHeadCafe - Software Developer Portal of Choice
Transparent NTLM Authentication With ADSI and ASP
http://www.eggheadcafe.com/tutorials...-authenti.aspx
.