+ Reply to Thread
Results 1 to 7 of 7

Help! I need to add together cells with a matching data validation

  1. #1
    Registered User
    Join Date
    04-10-2010
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    9

    Help! I need to add together cells with a matching data validation

    Hi there

    Hope someone can help! I am trying to make a basic account sheet to categorise my finance transactions. I need to add together values that fall into the same cateogry. I.E. add together all expenses of the same cateogry. one column has a value and the next column has a category see attached sheet.
    Attached Files Attached Files

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Help! I need to add together cells with a matching data validation

    how about
    =SUMIF(E3:E12,"=Mortgage",F3:F12)
    =SUMIF(E3:E12,"=Insurance",F3:F12)
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    04-10-2010
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Help! I need to add together cells with a matching data validation

    Thanks very much Vlady! Your a legend, just what I was looking for

  4. #4
    Registered User
    Join Date
    04-10-2010
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Help! I need to add together cells with a matching data validation

    Just tried it... , I need it to calculate all the Values in column D that have morgage or insurance next to them in colum E. Column F is not required in the calculation

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Help! I need to add together cells with a matching data validation

    sorry thought was f

    just change the F3:F12 there with D3:D12

  6. #6
    Registered User
    Join Date
    04-10-2010
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Help! I need to add together cells with a matching data validation

    Thanks very much vlady! works great

  7. #7
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Help! I need to add together cells with a matching data validation

    welcome the "Forum"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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