+ Reply to Thread
Results 1 to 4 of 4

[Solved] Make a sum of cells based on a value in another cell

  1. #1
    Registered User
    Join Date
    06-10-2021
    Location
    Netherlands
    MS-Off Ver
    Online 365
    Posts
    7

    [Solved] Make a sum of cells based on a value in another cell

    Hi,

    Probably a very simple question for you Excel pro's but I'm looking for a way to make a sum of all values that are still 'pending'.
    I've got amounts in column F and in column H I've got "Pending" or "Paid". I want to make a sum of all values that are still 'pending' to be returned in a cell, say K2.
    So for example I've got:
    F3 = 500, F4 = 300, F5 = 100
    and
    H3 = Pending, H4 = Paid, H5 = Pending

    I want a sum in K2 that returns, in this case, "600", because 500 and 100 are pending. If H5 changes to 'Paid', I want K2 to return "500" because that's the only pending payment.

    I'm bound to Office 365 unfortunately due to work restrictions.

    Appreciate your help!
    Last edited by iyvee; 06-10-2021 at 03:53 PM.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: Make a sum of cells based on a value in another cell

    Welcome to the forum.
    You can use SUMIF. The format is =SUMIF(range to check, what to check, range to sum). So using your example:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Change the ranges to the real ranges you have.

    Hope that helps.


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

    U moet de juiste referenties daarin zetten in plaats van de voorbeelden H3:H5 en F3:F5.
    Hopelijk helpt dat een beetje.
    Last edited by Aardigspook; 06-10-2021 at 02:02 PM.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Registered User
    Join Date
    06-10-2021
    Location
    Netherlands
    MS-Off Ver
    Online 365
    Posts
    7
    Quote Originally Posted by Aardigspook View Post
    Welcome to the forum.
    You can use SUMIF. The format is =SUMIF(range to check, what to check, range to sum). So using your example:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Change the ranges to the real ranges you have.

    Hope that helps.


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

    U moet de juiste referenties daarin zetten in plaats van de voorbeelden H3:H5 en F3:F5.
    Hopelijk helpt dat een beetje.
    This sure helps! Already saw this formula when googling but was confused as to how to apply it.

    Thanks!
    Bedankt, aardige spook

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: [Solved] Make a sum of cells based on a value in another cell

    You're welcome / graag gedaan.

+ 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. [SOLVED] How to make multiple cells change color based on one cell's text.
    By Ducky405 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2017, 03:49 AM
  2. Replies: 3
    Last Post: 05-15-2017, 03:24 PM
  3. Make certain cells uneditable based on values in other cells
    By ramatthews in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-03-2016, 11:53 AM
  4. Replies: 7
    Last Post: 10-01-2015, 04:45 PM
  5. How to make cells show blank based the cell to the left
    By ScottKiwi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-18-2015, 03:57 PM
  6. Replies: 0
    Last Post: 03-08-2013, 06:34 AM
  7. To make several cells mandatory based on other cell input.
    By nukecity83 in forum Excel General
    Replies: 1
    Last Post: 10-13-2009, 05:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1