+ Reply to Thread
Results 1 to 4 of 4

Total Sum box

  1. #1
    Registered User
    Join Date
    07-28-2011
    Location
    London,England
    MS-Off Ver
    Excel 2010
    Posts
    22

    Total Sum box

    Hi,

    I'm trying to put a sheet together for an outgoings sheet - what I'd like is when you select 'yes' from the paid column the 'total paid to date' adds the amount for that bill.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,268

    Re: Total Sum box

    In B9:

    =SUMIF($C$3:$C$8,"yes",$B$3:$B$8)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-28-2011
    Location
    London,England
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Total Sum box

    Brilliant - Thank you so much !!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,268

    Re: Total Sum box

    You're welcome!

+ 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. Replies: 6
    Last Post: 06-24-2016, 12:40 PM
  2. [SOLVED] Macro to Total a Column Up 15 cells and place total in cell of last row
    By guitarsweety in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-20-2014, 05:25 PM
  3. Replies: 3
    Last Post: 03-06-2014, 12:48 AM
  4. Pivot Chart Running Total - Removing Current Year Future Total
    By car3489 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-27-2013, 03:35 AM
  5. Sub-Total / Total / Grand Total Help Needed
    By jenniferexcel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2013, 12:00 PM
  6. Replies: 0
    Last Post: 02-07-2013, 08:42 PM
  7. Find total time taken by each person to process total number of letters.
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2010, 10:04 AM

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