PDA

View Full Version : Quick & Dirty Excel


smidsy
12th November 2021, 05:00 PM
Hey Guys,
Aside from one job twenty years ago where I was entering data in to pre-created forms I have never used Excel - I've just never had need for it.

I now have a task where I have 41 (and growing) lines of numerical data, with two numbers on each line - so three columns, one for the item description and two columns of numbers.
Without going through a massive learning curve is it possible to have this data in an Excel sheet so I can update individual lines while Excel keeps a running a total of the two columns.
Basically what I am looking for is a way to not have to add up two lots of 41 numbers all the time.
Is there a website or video which will show me how?
I'm using Excel 2007 so there's no help from MS.
Cheers
Smidsy
BobL
12th November 2021, 05:11 PM
=SUM(startcol/startrow:endcol/endrow)

Lets say the first column starts at B3 and ends at B44.
At anywhere but usually at B45 you'd enter
=SUM(b3:b44)

Lets say the second column starts at C3 and ends at c44.
At anywhere but usually at C45 you enter
=SUM(b3:b44)
Chris Parks
12th November 2021, 05:45 PM
There are many videos of the type you need on youtube. Seeing someone doing it on video is less painful than learning via any other method.
aldav
12th November 2021, 07:15 PM
=SUM(startcol/startrow:endcol/endrow)

Lets say the first column starts at B3 and ends at B44.
At anywhere but usually at B45 you'd enter
=SUM(b3:b44)

Lets say the second column starts at C3 and ends at c44.
At anywhere but usually at C45 you enter
=SUM(b3:b44)

:? :no: Should have concentrated more on not being first to answer Bob. Reminds me of my first effort making a box with the Leigh D4. :D
damian
13th November 2021, 11:57 AM
If you are still having problems pm me your email. I'll build it for you. If you email me your numbers I'll put them in and all you'll have to do is add to them.

The easiest way to do it is allocate the first 3 columns to your data.

Next select a cell to the right and type =SUM(

then select the whole column you want to add

then close the bracket )

hit return.

This way as you add data later it will automatically be added to the total.

Repeat for your other column.

I just built it but can't put it on the forum. Message me an email and I'll send it to you. Took about 2 minutes, cos I'm blind... :D
rwbuild
13th November 2021, 01:53 PM
Also lock the sum formula cells and unlock data entry cells and protect the sheet