Auto-filling formulas etc

N

Neil G

Why is it that if I use the drag cell method to auto-fill formulas, it won't
recognise increments of more than 1
For example.

I create two consecutive sum cells thus
Cell F15 has =sum(B15:D15)
Cell F16 has =sum(B20:D20)

I want to select those two cells and drag down, so that the sum in each row
increments by 5.
IE F17 would become =sum(B25:D25) and so on.

Is there a logical reason that I can't do this

Thanks
Neil
 
F

Frank Kabel

Hi
enter the following formula in F15:
=SUM(OFFSET($B$15:$D$15,(ROW(1:1)-1)*5,0))
and copy this down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top