+ Reply to Thread
Results 1 to 2 of 2

Total for two Different Columns

  1. 10-01-2014, 07:58 PM #1
    Mrrickc
    Mrrickc is offline
    Registered User
    Join Date
    09-12-2014
    Location
    Red Hook, Ny
    MS-Off Ver
    Version 2007 and 2010
    Posts
    6

    Total for two Different Columns

    Hi,

    I just can't figure out how to get a total from two different columns? I want to add the numbers in column C, Row 1 thru 10 to column E, Row 1 thru 10 with the grand total being in Column E, Row 11.

    Any help would be appreciated.
    Thanks
    Rick
    Reply With QuoteRegister To Reply
  2. 10-01-2014, 08:05 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Total for two Different Columns

    Hi,

    Presumably
    =SUM(C1:C10)+SUM(E1:E10)

    ...and whilst I'm here would you change the location in your profile to something sensible and meaningful please. We ask for this for a reason.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] sum columns for YTD total
    By humpaco in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-01-2018, 08:08 AM
  2. Delete Columns and Sum Row total
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2011, 07:34 PM
  3. Sum variable columns and then sum total
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2011, 09:52 AM
  4. Function recognizes two columns and adds total of two other columns
    By grafx77 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-18-2007, 09:09 AM
  5. how do i add up 3 columns to get a total
    By dekmag in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 12-26-2005, 04:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1