Share via

adding and subtracting all the way down a column, repeating a formula.

Anonymous
2014-01-08T16:37:54+00:00

I am trying to figure out a way to repeat a specific formula pattern in excel spreadsheet. 

The formula is simple- add two numbers get a total, take the total and subtract a number for final total and then repeat again taking the final total and adding a number for a total, subtract a number to get final total over and over again.

add number get total, take total number and subtract a number to get final total, start again.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2014-01-09T21:09:50+00:00

    One possibility is using this logical expression in column G:

    =IF(ISBLANK(F1),"",E1+F1)

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2015-12-28T11:54:49+00:00

    How can i Subtract every number from a column in any number from naother column. 

    Therefore the results will be a A col X B col matrix.

    Is it possible?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2014-01-12T00:21:35+00:00

    I assume that you are working from the top of columns A & B down the page.

    Hope this is what your after.

    2 people found this answer helpful.
    0 comments
  4. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2014-01-08T19:00:25+00:00

    The foundation formula is rather straightforward: =A1+B1-C1

    However, what you mean by "repeat a specific pattern" is rather vague. It depends on how the data is arranged & what the intent is as to what else might be involved, such as whether the subtrahend is a constant or a variable.

    If nothing more than a list with 1 value in column A, 1 value in column B & the subtrahend in column C, for example, just put that formula in coumn D then copy down as far as necessary.

    Another option: With the values in A1 & B1 put =A1+B1 in cell C1, the subtrahend in D1, in E1 use =C1-D1, then copy it down the column. Or if the subtrahend is a constant just put it in the formula [e.g., =C1-20 ] or store it in a different single cell such as F1 -- The formula would then be =C1-$F$1.

    There are other possibilities as well but without any details attempting to list them all is impractical & pointless.

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2014-01-09T14:48:35+00:00

    Thanks so much you helped me start to figure this out but I still have some confusion. Here is what I am trying to do, add two dollar amounts and get a total, take that total and minus a dollar amount to get a final total and then start over with the last totaled dollar amount and add new $$ amount and so on so if you go down the column it would look like this

    A-  $4

    B-  $5

    C-  $9  =sumA1+B1

    D-  $6  (not a constant, varies)

    E-  $3   =sumC1-D1

    F-  $7

    G- $10  =sumE1+F1

    H- $9

    I -  $1  =sumG1-H1

    and so on all the way down the page. I did put in the formula's and copied down the page and it works but I don't want to show any numeral ($$ amount) in the cell until I plug in a number, is that possible?

    Right now when I get an answer in C1 it shows in G1 and all other cells down the page.

    0 comments