Ask Experts Questions for FREE Help !
Ask
    maxsc's Avatar
    maxsc Posts: 23, Reputation: 1
    Junior Member
     
    #1

    Jul 1, 2017, 11:56 AM
    How to sum a whole column and subtract it from another column in excel ?
    I have 3 columns, I want column A's rows to be summed and then the result to be subtracted from the sum of column B and then the result to be shown in column C.

    Whatever formulae I write keeps giving errors and nothing works!
    Wondergirl's Avatar
    Wondergirl Posts: 39,354, Reputation: 5431
    Jobs & Parenting Expert
     
    #2

    Jul 1, 2017, 12:00 PM
    Switch columns: move column A data into column B and column B data into column A?
    maxsc's Avatar
    maxsc Posts: 23, Reputation: 1
    Junior Member
     
    #3

    Jul 1, 2017, 12:03 PM
    sorry, I don't understand how that's going to work!

    right now I wrote this but it doesn't work
    =SUM(A3:B999)-(B3:B999)
    Wondergirl's Avatar
    Wondergirl Posts: 39,354, Reputation: 5431
    Jobs & Parenting Expert
     
    #4

    Jul 1, 2017, 12:19 PM
    I Googled and found this:

    The Joel on Software Discussion Group (CLOSED) - How to subtract two columns in Excel?

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

While working on an Excel spreadsheet is there a way to bring column A over to column [ 2 Answers ]

On the Excel program is there a way to bring column A over to column X so I can see the Column A while entering into Column X

Excel - Copying a row to a column [ 3 Answers ]

I have a list of data in Row 1 that I would like to be displayed down Column A instead. Is there an easy way to transfer it from one to the other?

Create column with descending numbers corresponding to data in another column. [ 1 Answers ]

I created an alphabetized column with names. In another column I put an x next to those names that were heads of households leaving the rest blank. I would like to create a new column that would recognize the x then insert a number in the cell next to the x in descending order (i.e. 1-50).

Column Protect in excel [ 1 Answers ]

How to protect the column in excel??


View more questions Search