+ Reply to Thread
Results 1 to 5 of 5

Sum of a range but with condition

  1. 02-27-2017, 07:31 AM #1
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Sum of a range but with condition

    hi,

    i want to sum of range but with condition

    here is sample workbook
    Capture.JPG
    Attached Files Attached Files
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *
    Reply With QuoteRegister To Reply
  2. 02-27-2017, 07:35 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,099

    Re: Sum of a range but with condition

    In F4, copied down:

    =IF(D6=D5,"",SUMIF(D:D,D5,E:E))
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 02-27-2017, 07:59 AM #3
    avk
    avk is offline
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Sum of a range but with condition

    As per your data try with :
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    copy paste down

    atul

    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
    Reply With QuoteRegister To Reply
  4. 02-27-2017, 09:11 AM #4
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Sum of a range but with condition

    Thank you for both of you

    but @Glenn Kennedy forum guru

    its working as i wanted

    a big thank you
    Reply With QuoteRegister To Reply
  5. 02-27-2017, 10:18 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,099

    Re: Sum of a range but with condition

    You're welcome and thanks for the Rep.
    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. COUNT DISTINCT sumproduct(1/countif(range;range) with condition.
    By campelliann in forum Excel General
    Replies: 1
    Last Post: 12-17-2015, 11:22 AM
  2. [SOLVED] My vba Transpose with condition, but its transposing the condition from other range
    By Franky alta in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-28-2015, 03:56 PM
  3. [SOLVED] Computation for a range of data with a range of condition
    By Dewdrop in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-26-2015, 07:01 AM
  4. if condition is true then copy the range to other range
    By pedjvak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2013, 04:56 AM
  5. open a comment to cell range upon true condition then removing comment on false condition
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 12:55 AM
  6. condition decide the range and SUM of the multiple condition
    By choy96 in forum Excel General
    Replies: 6
    Last Post: 05-06-2010, 10:06 PM
  7. [SOLVED] Create/copy combo boxes in one range if condition is met in a different range
    By LB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2005, 08:05 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