excel help required

Percybridge

I am still struggling with my spreadsheet and need yet another forumla.
Sheet 1 has a calculation based on two variables which are in cells B4 and B5.
So when different values are inserted in either B4 or B5, a calculation is made.
I would like another sheet containing a grid or table.

On the top row I would like to be able to add various values, similarly on the first column.
So for the first figure, (say f3 on the second sheet) , would be the result of 1000 in b4 and 3000 in b5 on sheet 1.
Is there a way of doing this?
I hope I have explained this properly.

Mr_Toad

It's a very simple thing to do.

on sheet 2 in cell F1 type the following

=SUM(Sheet1!B4+Sheet1!B5)

Or if you don't want to type it you can type =Sum( in F4 then go to sheet 1 and click in cell B4 and Excel will insert the Sheet1!B4 part you then tell it you want to add by typing the + then click in B5 and then finish by adding the closing bracket.

paddyrg

=SUM(Sheet1!B4,Sheet1!B5)

FTFY :-)

Stompa

Mr_Toad wrote: »

It's a very simple thing to do.

on sheet 2 in cell F1 type the following

=SUM(Sheet1!B4+Sheet1!B5)

Is there anything to be gained by using both SUM() and + though?

=Sheet1!B4+Sheet1!B5

would be sufficient, or alternatively:

=SUM(Sheet1!B4,Sheet1!B5)

Mr_Toad

Stompa wrote: »

Is there anything to be gained by using both SUM() and + though?

=Sheet1!B4+Sheet1!B5

would be sufficient, or alternatively:

=SUM(Sheet1!B4,Sheet1!B5)

No absolutely not. As with all things Excel there are several ways to do the same thing.

I've just got into the habit of doing stuff long hand to aid readability on more complicated stuff. In the past I've spent ages trying to remember what stuff does when you get a long and complicated formula. It's easy to forget the simple stuff if you don't use it.