# Skipping rows in a formula

L

#### Legacy 269768

##### Guest
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.

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Something like:

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

Replies
17
Views
389
Replies
9
Views
679
Replies
14
Views
356
Replies
1
Views
175
Replies
3
Views
148

1,203,061
Messages
6,053,307
Members
444,651
Latest member
markkuznetsov1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back