+ Reply to Thread
Results 1 to 2 of 2

hlookup 2 values on 2 rows and sum column

  1. #1
    Registered User
    Join Date
    05-15-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    12

    hlookup 2 values on 2 rows and sum column

    Hi all,

    I am looking for a formula which will do a hlookup on 2 rows and return the sum of the column

    For example:

    Apple Apple Apple Apple Orange Orange Orange Orange
    Blue Red Yellow Pink Blue Red Yellow Pink
    2 4 5 1 23 3 4 2
    234 34 34 2 534 53 2 1
    5 334 345 3 534 234 34 34
    234 234 234 4 3543 345 345 345

    the formula needs to be able to lookup across row 1 for "Apple", and Across row to for "Pink" and return the sum of the values under that column, so the result would be 10.

    Any advice?

    Cheers,

    Dexter

  2. #2
    Registered User
    Join Date
    05-15-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: hlookup 2 values on 2 rows and sum column

    sorry table isnt as neat as I had hoped...

    Under Apple and Pink the numbers are 1,2,3,4

+ 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