Results 1 to 3 of 3

Sumif using match when target is not on same row...

Threaded View

  1. #1
    Registered User
    Join Date
    07-25-2010
    Location
    PA
    MS-Off Ver
    Excel 365
    Posts
    47

    Sumif using match when target is not on same row...

    Hello all,

    On sheet2 i have a list of six values:

    cat
    dog
    mouse
    tiger
    giraffe
    fox

    On sheet1 I have over 10,000 records that will contain 1 of the above values.

    In words here is what I want to do...

    in the column next to cat. find every value on sheet1 column A that contains cat then return the sum from column H of those values only. The problem is i need excel to look at column H offset by one row.
    So if on sheet1 "Cat" is found in cell A14 i need it to sum the value in H15

    I hope what I'm asking makes sense.

    I thank you all for your help in this great forum.
    I look forward to your replies!
    Last edited by shhhhh22; 12-29-2011 at 01:40 PM.

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