Skipping rows in a formula

[Legacy 269768]

Hello everyone,

First time here and English is not my first language, so I'll try to be as clear as I can be. I searched the forum during an hour for answers, and I found a few but I could not find them all. Maybe because it's too simple. So here it goes.

I found how to do the sum of every 3rd row in a column using a formula like this one: =SUMPRODUCT(--(MOD(ROW(A1:A185),3)=0),A1:A185)
Now what I would like to achieve is a much simpler way of doing (A1*G1)+(A4*G4)+(A7*G7) and so on.

I also found out how to round up the value of a cell to 1 using this formula: =(IF(A2>0,1,0))
I would like to be able to the sum of A2 rounded to 1 multiplied by the value of H2 in a more simple manner than =((IF(A2>0,1,0)*H2)+((IF(A5>0,1,0)*H5)+((IF(A8>0,1,0)*H8) and so on.

Thank you very much.

 

[Aladin Akyurek]

Something like:

=SUMPRODUCT(--(MOD(ROW(A2:A100),3)=0),--ISNUMBER(A2:A100),--(A2:A100>0),H2:H100)