Beginner Excel Spreadsheet help please

[deniser]

As a completely novice user of Excel, can someone please help me with the formulas?

I've created a basic table with columns and rows. What I need to do is get the figure in each row in column B (which is designated as an amount in £sterling) to multiply by the number in column C to create a total £ amount which is listed in Column E and then for the total of all of Column E to add vertically to give me the final total.

Can anyone tell me how I get the formulas to insert into the table?

Many thanks!

 

[Jaydee]

So if the first line of the table is line 3, in E3 type =c3*b3 and then copy that formula down to the last line of the table.

In the cell that you want the total to appear (let's say it is E20 and the table totals are in E3 to E18) you would type =sum(e3:e18)

 

[deniser]

So if the first line of the table is line 3, in E3 type =c3*b3 and then copy that formula down to the last line of the table.

In the cell that you want the total to appear (let's say it is E20 and the table totals are in E3 to E18) you would type =sum(e3:e18)

Thank you so much - I will have a go.

 

[3cellhosting]

Hi Deniser,

Jaydee is correct for a simple sum. If you ever need more complex sums you will need to consider using brackets to seperate each calculation. Look in the Excel help file for details.

I always find the function wizard a help with the more complex formulas...

1. Place cursor in cell you want the answer to appear.
2. Top menu > Insert > Function - this brings up the wizard
3. Select the type of help you need in this case SUM which is in the Math & Trig section
4. Then show the range of figures you want added.

The wizard can help a lot with nested and if commands.

Hope this helps

David

 

[big bad bernie]

Hi

Highlight the cells you want to add up then. go to sum and press the tick. this should be your formula

 

[deniser]

Thanks to you both. I have put the formulas in but how do I get it to display the actual sums? At the moment column E now just has the formulas visible not the result. What do I have to do to get it to do the actual calculation?

Many thanks.

 

[MikeJ]

Put an equals sign at the front. You actually need to type...

=b3*c3

 

[3cellhosting]

Hi Deniser,

With Excel go to Tools > Options and select the 'calulation' tab.

Make sure that the selection is set to 'Automatic' then all formula results will be displayed.

Hope this helps

David

 

[deniser]

Put an equals sign at the front. You actually need to type...

=b3*c3

I have typed exactly that. The first time I did it a moving box appeared around it but after copying it down the column it is now static.

 

[deniser]

Hi Deniser,

With Excel go to Tools > Options and select the 'calulation' tab.

Make sure that the selection is set to 'Automatic' then all formula results will be displayed.

Hope this helps

David

It doesn't have Tools but I have ticked Automatic under "Calculation Options" which I guess is the same thing. But it still doesn't want to calculate.

Could it be because I have a couple of blank fields in some of the columns where I don't have the figures yet? Would that stop the whole table from calculating?

 

[GBTradesmen]

Is it the total at the bottom of your column E that is not displaying?

If so I usually use =SUM(E3:E11) in the cell you want to display your total. You can change the values inside the brackets to whatever you need. The example here will add up everything from E3 to E11 inclusive.

 

[spreadsheetsdirect]

It doesn't have Tools but I have ticked Automatic under "Calculation Options" which I guess is the same thing. But it still doesn't want to calculate.

Could it be because I have a couple of blank fields in some of the columns where I don't have the figures yet? Would that stop the whole table from calculating?

You might have the cells formatted as Text. Highlight them, right click on the mouse and select Format Cells. In the Number tab select General. You will probably have to edit the cells with the formula in to make them revert to formulas. Just select the first cell, press F2 to go to edit mode and then Enter. You should get the formula result in the cell. Just drag down for the other cells.