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:




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!

Maybe?

Maybe?

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

Hi,I do not understand which is the question.

Hi,

I do not understand which is the question.

Is it this

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

or something else

Mike