+ Reply to Thread
Results 1 to 3 of 3

Formula to add multiple vlookups

  1. #1
    Registered User
    Join Date
    12-21-2007
    Posts
    20

    Formula to add multiple vlookups

    I am having an issue figureing out how to make this work...

    Lets say I have a spreadsheet of data.
    Type Amounts--------------
    A 244 767 567
    A 100 100 100
    B 40 123 243

    Totals
    A 344 867 667
    B 40 123 243

    How would I get the A's to total at the bottom. There can be multiple A's throughout a very large list of data. Normally if it was only one row of A's I would use a vlookup. How can you get that functionality with more than one row???

    Any help is greatly appriciated...

    Thank you
    RAH
    Last edited by RAH; 03-03-2008 at 08:29 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Like this:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-21-2007
    Posts
    20
    Thanks that works great!

+ 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