# sum of subtraction every two row

## sum of subtraction every two row

I have been thinking of this but cant figure it out:

For example I have a Col start from row 10 (B10) going down. The number of row can be variable, but it should be odd number, the last row will not be count. Now I want the SUM of the subtraction of every 2 cell next together. Ex: I have B10:B21 then I need (B2-B1)+(B4-B3)+(B6-B5)+.+(B20-B19). How can I formula this?

Visit publisher's web-site: sum of subtraction every two row

## Related Tutorials

### simple subtraction

For each row of data, I want to display the difference between the value in cell C of the current row, and C in the next row. eg where "x" is the current row:

=SUM (C(x+1), -Cx)

How do I create this formula ?

### Subtraction of H:MM

I am trying to set up a timesheet that will automatically add up the hours worked for each day (stop time - start time), then sum up the week and convert it to a decimal (need 4.5 hours vs. 4:30). I have the conversion from H:MM to a decimal, but for some reason the hours are not summing up properly once they go over 24 for a given week. If they are under 24, then the formulas work fine. What am I doing incorrectly?

### subtraction of negative numbers

I'm trying to create an equation that, on occasion, will result in a subtraction of a negative, which then results in a larger negative number than it should be.

So for example:

=sum(A1 - B1)

A1 = -50

B1 = 40

so the results of this equation is -90, but in reality it should be -10.

seems simple but it's confusing the hell out of me.

### Automatic Subtraction on xl2007

Firstly this is my first post, so I hope I'm putting it in the right forum.

I am preparing a worksheet to keep details of my running total in paying off a certain financial sum. The payments and sums repaid are irregular.

Say, for example, the total outstanding sum is £100 and I put that figure in cell D1. I want to enter the repaid amounts down from cell C2.

Is there any easy way that when I enter the repaid amount so that it will automatically be subtracted from the first and subsequent figures in column D.

If anyone has the time to consider this I would be most obliged as I can't count, especially backwards! And when I ask for an 'easy way', I mean I'm an absolute beginner with excel and have no knowledge of macros etc.

Thanks for your time and for allowing me into these forums.

### Formulating cells

I'm trying to total a column and within it I have created rows that total by sum and rows that total by subtraction. My total at the bottom of the column is only showing the rows totaled by sum and not including rows totaled by subtraction.

## Related Applications & Scripts

### DataTable or Data Grid

Display of data through DataTable facilitates data management: - The rows can be ordered by clicking on the header of the column that you wish to order by. - You can set your own table size: set width, height, or both. If you set the size, scrolling bars will be shown when the amount of data requires it. - For tables with a high number of rows: Rows can be separated in pages, thus allowing to move between pages; you can also change the amount of rows per page; - Each row in the table will show a column defined by user - either Delete the row, or Edit it. Packaged into a Dreamweaver extension. No hand coding needed.

### MySQL Database Report Generator

Generate your database reports with this wizard in only a few minutes on any of your existing MySQL databases. Since this is a php driven application you simply upload the application files to a folder within your web site and you are ready to generate reports. Execute statistical queries such as sum a column.

This MySQL database report tool is simple to use even for the novice. No coding experience required.

### Guess And Win Script

You need to guess the number (between 1-1000). When you come first time to the site you have 1 chance to guess the number, if you guess right you transfer to information page and you can prize from our Prizes page, but if you guess wrong, you dont have another chance to guess the sum.

You can get more chances by referring your friends, for 3 people that you refer you will get 1 chance to guess the number, or if you dont want to refer your friends you can donate the site by paypal, if you donate 1$ you get 1 chance to guess the number, if you donate 5$ you get 5 chances to guess the number. You have multiple revenue sources: Adsense, Adbrite, ClickSor, CPALead, etc, and donations by Paypal.

### XML Dynamic Text Effects

This is a collection of 12 very cool text effects. The text used is dynamic, loaded from a XML file. It supports multlines and detects automatically when a word is finished.

In the XML file there can be customized different parameters like the text effect to play, space between words, how many letters will be on a row or the line height.

It is very easy to integrate with other animations and to customize different properties like font size, color or filters.

### Links PPR: Links directory management script

This script allows you to have links directory where link ranking in category and in search results is based at advertiser bids. It contains all advertiser features script for work with advertisers ( create profile, edit profile, add/modify/delete link, change bids, view stats, payment form).

It allows you to have bidded and non bidded links at directory. Paid links ranking depends on bids, all free links at the bottom of the category page.

All the links (including paid ones) require admin review before being included in the directory. Admin can show/edit/delete profile of every advertiser, change balance of advertiser, approve or decline link or/and money transaction, and email to all advertisers or those whose balance is as little as the requied sum ($5 for example - customizable), see earning stats.