+ Reply to Thread
Results 1 to 2 of 2

How to use a lookup table that will add alike numbers

  1. #1
    Registered User
    Join Date
    12-16-2011
    Location
    Colorado Springs, CO
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question How to use a lookup table that will add alike numbers

    Employees.xlsxHello,
    I am trying to compile a spreasheet and have become stuck. I am needing to do a VLookup. What I need is the formula to look for an account number and add all values associated with that account number. (Please see attached to see what I am talking about). I would appreciate any help. Thanks!!!!

    Crystal

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: How to use a lookup table that will add alike numbers

    Use

    =SUMIF($G$2:$G$13,G2,$E$2:$E$13)
    or
    =SUMIF($G$2:$G$13,"a203",$E$2:$E$13)

    or alternatively use pivot tables if you need sums of all individual accounts
    See column I:J of attached
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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