Add Rows Columns to a Worksheet

Welcome to the OzGrid Rambo! lol

We can help. Just give us more information. Like what Sheet/Column/Range
do you want a formula or a VBA solution.

Regards,
Barry

Click the Autosum button. (You should see a yellow Tooltip that says "AutoSum" when you are over the correct command button.) If you don't go to the Tools Menu, choose Options, click the general tab, check the Function tooltips box, click ok.

Make sure the Calculation is on Automatic! If not can you submit a sample and we'll get it working for you.

Barry

Howdy. You need to be in the cell where you want to sum to be. When you click on the Autosum button, you should see something like:

=SUM(B2:B10)

If not, then it might that you have an empty space just above the cell, and you will only see:

=SUM()

What you need to do is put the first cell reference in, followed by colon ( : ) then the second cell reference (to match the first formula above).

Okay, if you click in I28, then on the toolbar hit the Autosum button (looks like Greek letter Sigma). You will see:

=SUM()

Then follow the steps I posted above. First cell I6, last cell I27,

=SUM(I6:I27)

If you want to get the sum for J28 and K28, select cell I28, then move the cursor to lower right corner. When it changes to a small black cross-hair cursor (like your tommy gun above ), then click and drag to the right and stop at K28.

If it will keep expanding, I would put the formula above the data (in cell I4, for example). Then change the reference to:

=SUM(I6:I1000)

(or some other large number)

That way, you will always have the data added in.

(There is another [more complicated] way, but let's get this resolved)

Well, it works properly. The real question is whether it will work for you now. Is that setup appropriate for you specific needs? If you want it refined we can work on that too.

BTW, this is ironic: I'm a mac user (as well as Windows at work) saving a MS product from certain destruction? :guitar: :dance:
[Edit: This relates to the original thread title.]

To have rows automatically inserted above the totals would require VBA, and can be done.

If you keep the totals above, then you can use the formulas on this attachment to have the hours and overtime automatically calculated. Since I didn't know what constituted double time I didn't include any formulas for that column.

See if this is what you were thinking about.

Quote from ShiftnSix

wow! that is exactly what i was trying to do!

Good.

Quote

i wish i could get this syntax thing figured out so i could do stuff like this...

One thing that is very helpful is to enable the Function Help. Tools > Options > General tab, and check "Function tooltips". When you enter a function in a cell, then on the Formula bar, the tip will highlight each portion you are working on.

Also, while in the Tools > Options > Edit tab, be sure to check "Extend List formats and Formulas" This will prove helpful in extending lists.

Quote

ummm, overtime is any hours over 8 (up to 12), doubletime (in CA) is anything over 12 hours in one workday (midnight to midnight) AND any hours (no matter if its only 1/2 an hour) worked on the 7th consecutive workday...(like, if you worked seven days in a row w/o a day off. if you work that seventh day its ALL doubletime). but on the eighth day, thats a new workweek in the eyes of the law...

Okay, then a formula can work here as well. The logic of the IF formula is, put a condition in the first spot (like this: =IF(condition ). Then put a comma, and follow that by what happens if this condition is true, then put a comma, and put in what happens otherwise. As you can see, you can add several nested IF functions.

=IF(Condition1,True1,IF(Condition2,True2,IF(Condition3,True3,Else)))

Quote

wow, i think i just confused myself with that stuff....lol

hmm... i really dont understand those help menus in this program

At least you are hanging in there. As you work with this more, you will can confidence in what you can do and what the Help files can provide. So, don't shoot the program, but coax it with a little honey... :congrats:

Actually, if you use those four dates I provided and select all four, then move the cursor to the bottom of that last cell, and click-drag down, Excel knows you want the next dates,a nd will automatically fill in, and it keeps track of changes of months, etc.