Excel help please!

[Cones]

I’m hoping someone with excel knowledge will be able to help.

I have been sent a table which calculates the total when I input the data. They haven’t added enough rows.

when I insert a row below, if inserts a blank row but won’t calculate all the info for me.

what do I need to do? Any help welcome!

Try inserting a row within the table rather than below

Or click and drag to highlight the last row and drag it down using the little + in the corner to copy everything a few rows down and then overtype with your new data

copy the row above, then 'paste special' 'formulae' in the new row.

maybe not formulae, maybe formatting, something like that.

The row with the total in, look at the formula. It will probably look something like =sum(B1:B65)

You need to amend the formula (across all cells in the total row) to include the new rows that you have inserted. So if you've inserted rows into row 66, 67 and 68, the formula needs to read =sum(B1:B68)

Pick a row that's not the header row, and right-click. Point to Insert, and pick Table Rows Above to insert a new row.

It’s worked! Thank you all so much 😘

Next time add the row above the last row, and it will automatically be included in the calculation at the bottom. If you add a row under the last row it won't be calculated.

Agree. Always much easier to have a blank row you aren't filling in at the bottom.

You all sound like excel experts. Any recommendations for books or videos for a complete beginner?

it will automatically be included in the calculation at the bottom

I agree, though I have spent wasted many, many unpaid hours search for an error traced back to it not being included, so I would always check.

Select the whole column and check the total shown in the bottom bar is the same as the total in the spreadsheet.

Don't have any suggestions, sorry.

I've picked it up over decades. Only just worked out how to format a number to show in thousands, so £14,789 shows as £15k. Yesterday.