Excel
(1)
SUMPRODUCT
(1)
COLUMN
(1)
MOD
(1)
SUM
(1)
SalesAid
(1)
Dguillett1
(1)

how do you total columns that are not adjacent

Asked By Lyn Kolf
21-Nov-09 08:44 AM
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?

Don Guillett replied to Lyn Kolf
21-Nov-09 09:20 AM
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.

Mike H replied to Lyn Kolf
21-Nov-09 10:05 AM
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
Post Question To EggHeadCafe