how do you total columns that are not adjacent

[Lyn Kolf]

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/tutorial...a-dd1b21b626c3/transparent-ntlm-authenti.aspx

 

[Don Guillett]

Maybe?

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

in message news:[email protected]...

 

[Mike H]

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