Looking for a formula to subtract a range of cells on Microsoft Excel?

I'm using Excel to complete a project and can't seem to figure out how to add a subtraction formula to the spread sheet.

If you need to subtract the total of a column or row, you can put a formula cell at the end of that column or row... ex. =sum(A1:A7)

And then subtract that cell's value in the cell you're working on now. It should be possible to change the color of the text in the first cell I mentioned so that it doesn't show up on the spreadsheet if necessary.

Try =(main reference cell)-Sum(other reference cell range)
ie =A1-Sum(B1:B4)

Tags

　　Project Tools 　　Project Software 　　Project Planning 　　Project Consulting 　　Project Manager 　　Project Management 　　Microsoft Project 　　Knowledge Solution 　　Knowledge System 　　Knowledge Transfer 　　Knowledge Manager 　　Knowledge Sharing

Related information

I need help. for a school project i downloaded a free 60 day trial of microsoft office 2007...?

when you downloaded the 60 day trial it should have given you a product code that would unlock it for the 60 days. Check to see if you got any emails from Microsoft about it. Id you want to swi...

When ever I hit the backspace button in Microsoft word 2007 the save as screen appears?

This is probably due to quickkeys or filterkeys as I think they're called. Go to your control panel and click accessibility options.Whle on the keyboard tab make sure none of the 3 choices ava...

I need a description of microsoft office 2007 visio ,office 2007 project and expression web?

The following sites will give you all the information asked. Visio Home Page - Microsoft Office Online Microsoft Office Live. Microsoft Office Visio. Search. Search. Try Visio 2007. Buy Visio 2...

I have a microsoft word project and i have to make a fake company name and sell a creative product. any ideas?

You could sale robots. You could go as simple as the little robot dogs and cats at the toy stores to big complicated robots that arent even out yet. You could probably even make some up.

...

Microsoft Project Server 2003 or Project Server 2007?

for something like this at the enterprise level i would demand some answers from microsoft directly.. you may get some tips here but this is likely something ms is aware of.

...

Using Microsoft Project 2000 do you use the cost management features? In what ways do you use it?

yes we use it to calculate the cost of resources which are included in the project. Good luck!!!

...

What is the microsoft project software?

It lets you plan out projects. It contains a gantt chart so you can see what pieces of the project are assigned to whom, what dependencies each piece has and what timeframe each piece should be do...

How do i export a video/movie, into a new format?

Use ConvertVid is software product for converting videos from one format to another.( Convert any video \ audio file to aonther format ) If you have iPod, mobile phone or want create DVD this produ...