I have the following Excel formula that sums all values from a specific column (Hrs):

```
=SUMPRODUCT(G3:ZZ7*(MOD(COLUMN(G3:ZZ7),3)=1))
```

How do I make the formula apply to specific rows, e.g. from 2 to 4?

0

I have the following Excel formula that sums all values from a specific column (Hrs):

```
=SUMPRODUCT(G3:ZZ7*(MOD(COLUMN(G3:ZZ7),3)=1))
```

How do I make the formula apply to specific rows, e.g. from 2 to 4?

`SUMPRODUCT`

. eg.`...(ROW(your_table)>=2)*(ROW(your_table)<=4)`

– Ron Rosenfeld Apr 20 '17 at 22:11