+ Reply to Thread
Results 1 to 7 of 7

How to check a list for a value and then sum all amounts where value is the same

  1. #1
    Registered User
    Join Date
    04-25-2019
    Location
    London
    MS-Off Ver
    19
    Posts
    5

    How to check a list for a value and then sum all amounts where value is the same

    Hi all,

    I'm trying to sort my finances out and as a result I'm categorising my spend on my credit card.

    As a result I have a very long list of items with a description (A) Category (B) and value (C)

    I want to be able to total the items in the list from a certain category

    For example
    Tesco - Petrol - £50
    Tesco - Food - £30
    Tesco - Petrol - £60
    Tesco - Food - £50
    Tesco - Petrol - £40
    Tesco - Food - £60

    Total Food = £140
    Total Petrol - £150

    What forumlar would work to review everything in a list of 300+ lines to check and sum all of these

    Thanks in advance for the help

  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
    79,398

    Re: How to check a list for a value and then sum all amounts where value is the same

    This maybe?

    =SUMIF(B:B,"Petrol",C:C)
    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
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: How to check a list for a value and then sum all amounts where value is the same

    The formula you're looking for is SUMIF:
    Please Login or Register  to view this content.
    That should be what you need, or at least close
    If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.

    If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.

  4. #4
    Registered User
    Join Date
    04-25-2019
    Location
    London
    MS-Off Ver
    19
    Posts
    5

    Re: How to check a list for a value and then sum all amounts where value is the same

    Great. that worked a charm.
    Now exploring that further is it possible to search Date range (D) as well?
    So for example check date and if it's in the month of April or range say 1st April to 31st April to do the same?

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: How to check a list for a value and then sum all amounts where value is the same

    That would be SUMIFS(): https://support.office.com/en-us/art...6-611cebce642b

    Or, this starts to feel like a pivot table would be a useful (maybe better) way to summarize the data: http://www.excel-easy.com/data-analy...ot-tables.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  6. #6
    Registered User
    Join Date
    04-25-2019
    Location
    London
    MS-Off Ver
    19
    Posts
    5

    Re: How to check a list for a value and then sum all amounts where value is the same

    Thanks everyone for your help! Great forum!

  7. #7
    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
    79,398

    Re: How to check a list for a value and then sum all amounts where value is the same

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Adding random amounts in a check register
    By CJ Mac in forum Excel General
    Replies: 8
    Last Post: 08-29-2016, 10:52 PM
  2. Sum amounts on List
    By nik7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-14-2015, 04:41 AM
  3. Replies: 0
    Last Post: 06-27-2014, 04:16 PM
  4. Replies: 3
    Last Post: 10-24-2013, 06:50 PM
  5. Date and flight number check to copy invoice amounts in one column
    By deadshine in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-04-2013, 11:29 PM
  6. [SOLVED] Calculating amounts in a single currency from a list of multiple currency amounts
    By Romsky in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-03-2013, 12:22 PM
  7. [SOLVED] Format dollar amounts for check printing
    By dford in forum Excel General
    Replies: 2
    Last Post: 11-20-2005, 08:20 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