Customize Autofill Feature

Hi, welcome to the forum

Do your columns have headings that are in any sort of grouping?

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

With numbers in A1:L1 enter SUM(A1:D1) in cell D2. Now select A2:D2. Right click the fill handle in the lower right hand corner of the selection and drag it to L2. A pop-up menu will appear. Select "Fill without formatting".

Does this do what you want?

@ dave, I think they want to be able to sum every 4 "sets" of columns

Originally Posted by FDibbins

@ dave, I think they want to be able to sum every 4 "sets" of columns

Hmmm. I would think this would adapt to that, too ...... but maybe I should wait for the workbook upload you suggested.

This is what I have.
1. remove the space in the headings in row 14 (or add a space to the day in column I) - they need to match.
2. your times are not really times, they are text, looking like times. If that is how you get the data, add a helper row, with this, copied across...
=TIMEVALUE(A1)
Otherwise in A2, enter 0:00
B1 = 0:15
highlight both and drag across.

I used the =TIMEVALUE(a1) in row 7, just so you can see how this works. Then...

	B	C	D	E	F
13		Mine
14	Hour	Day1	Day2	Yours
15	1	16632	66528	16632	66528
16	2	16590	66360	16590	66360

C15=SUM(OFFSET($A$1,MATCH(C$14,$I$2:$I$6,0),MATCH(($B15-1)/24,$A$7:$H$7)-1,1,MATCH($B15/24,$A$7:$H$7)-1))
copied down and across

Here are a couple of possibilities:

And here is another done with a copy of summary table in E14:G16.

Formula:

Please Login or Register  to view this content.

BTW the row headers in I2:I6 were Day1, Day2 .... etc. The column headers were Day 1, Day 2 ...... (with a space). I changed them in the upload. This formula works in my upload but will not work in your upload till that is changed.