Excel formula question

[DellAxim]

I'm trying to set up a spreadsheet in Excel, but I'm having a little trouble setting up the formula. It's been too many years since I took excel or math classes.

What I'm trying to do is add together two cells, and then subtract that value from another cell. Can anybody tell me what formula I can use?

 

[cuemasterfl]

Something like this:

=sum D5-(A1+B1)

Where D5 is the "other" cell you refer to.

 

[arkamw]

I think you have to take the sum out of the above formula (at least, in 2k). Reads:

=d5-(a1+a2)

If you ARE trying to sum together a large set of data, then sum is included:

=d5-sum(a1:a50)

If all you are doing is adding two cells together, summing them works, but it's easier just to add them up.

 

[cuemasterfl]

I think you have to take the sum out of the above formula (at least, in 2k). Reads:

=d5-(a1+a2)

If you ARE trying to sum together a large set of data, then sum is included:

=d5-sum(a1:a50)

If all you are doing is adding two cells together, summing them works, but it's easier just to add them up.

You're right. You can leave the sum out, or you could use something like:

=SUM(F9-(B6+B7)) which I just tested and it works.