+ Reply to Thread
Results 1 to 3 of 3

SUMIF &/or LOOKUP

  1. #1
    Registered User
    Join Date
    07-12-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    9

    SUMIF &/or LOOKUP

    I have a table of data that I need to sum up based on product code thereafter by customer. I have tried using nesting SUMIF and AND and also nesting SUMIF and LOOKUP but I think I may have the formula wrong. Any advice please???

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: SUMIF &/or LOOKUP

    Perhaps you should explore =SUMIFS()?
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

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

    Re: SUMIF &/or LOOKUP

    Use SUMIFS if you want summimg up by both criteria. Probably uplaod a sample worksheet?
    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)

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