Excel Formula Question

JennyB

Apologies if this is the wrong place to post. I've had this problem for ages and thought I might give posting on here a shot!

I have a formula which is "=SUM(F332:F338)". In the next box down in the column I want it to read "=SUM(F339:F345)" and so on - i.e. this is totalling up consecutive groups of seven boxes running down a column. However, when I put in these two formulas, highlight then and drag the right hand corner down, instead of saying "=SUM(F346:F352)" it says "=SUM(F334:F340)"... eh?! It's just added one on per column instead of 7. I have this problem a lot when excel just doesn't know how to copy the pattern that I've got and I end up having to type all the formulas in manually which is really time consuming.

Can anyone help? I'm sure the answer to this is an easy one but I'm stumped. I would be so eternally grateful to have a solution - I've struggled with this for years! I use excel a lot but I'm totally self-taught and so I'm not hot on formulas (amongst other things :rotfl: )

Dennis99

Why not use autosum? Click in the box under your column of figures and click the autosum symbol press return, job done. :j

Chippy_Minton

You can use a pivot table to group the data.

Lots of info on the web, e.g. http://peltiertech.com/Excel/Pivots/pivottables.htm

JennyB

Autosum doesn't work at all unfortunately - that just totals the column above (am I doing something wrong? ) This is probably my fault for not explaining well but these totalling up formulas are on a separate worksheet to the boxes they are totalling. I left the reference to the other worksheet out of the formula for simplicity.

JennyB

Chippy - that might just work thanks!

kevin.philips

The best excel board on the internet I'm sure will help you with as many Excel answers as you have questions.

https://www.mrexcel.com/board2