+ Reply to Thread
Results 1 to 3 of 3

Calculate sum for selected entries in column c plus selected entries in column d.

  1. #1
    Registered User
    Join Date
    03-28-2024
    Location
    Little Rock, AR
    MS-Off Ver
    Excel for Mac
    Posts
    1

    Calculate sum for selected entries in column c plus selected entries in column d.

    Extreme novice here and my quick scan of threads did not answer my issue. Apologies if already posted, I just didn't find it.

    I have a spreadsheet where I enter my income from contract A (in column B) and income from another contract (in column C). I want to total all of my income for that particular month in a different column so that I can visualize the total income for a particular month. I want to do this for every month. I'm spending a lot of time going nowhere and getting loads of errors in my formulas. Suggestions?

    TIA

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Calculate sum for selected entries in column c plus selected entries in column d.

    Welcome to the forum.

    It would helps if you attached a sample Excel workbook, and you can do this by following the guidelines in the yellow banner at the top of the screen.

    Pete

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Calculate sum for selected entries in column c plus selected entries in column d.

    One way

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Where column "D" is the Month you want to total

    given columns B:C are contract-specific

    But as per previous post, a sample workbook is needed.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Summing selected entries
    By RoyYates in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2023, 02:30 AM
  2. [SOLVED] Display column entries in row as vertical entries in a userform listbox
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-22-2016, 08:10 AM
  3. Replies: 13
    Last Post: 05-11-2014, 06:51 PM
  4. Replies: 1
    Last Post: 02-01-2013, 03:38 PM
  5. [SOLVED] Rendering Column Values for Selected Entries
    By rentb23 in forum Excel General
    Replies: 1
    Last Post: 01-16-2013, 07:34 PM
  6. Removing repeat entries in a long column of data entries
    By kaizhong1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2010, 01:31 PM
  7. Sum selected entries from a table
    By aljanga in forum Excel General
    Replies: 7
    Last Post: 10-26-2009, 04:22 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1