+ Reply to Thread
Results 1 to 3 of 3

SumIf using 2 criteria??

  1. #1
    Registered User
    Join Date
    02-19-2007
    Posts
    1

    SumIf using 2 criteria??

    I have been having difficulty figuring out a way finding the sum of QTY (M) using 2 different criteria. One using company name (column A) and prouduct serial number (column I).

    I have no problem simply finding the QTY of a specific product (using serial #) through sumif, but havent figured how to do it by doing customer and product serial at the same time.

    Is there a way to use the sumif function for 2 seperate criteria? One is text...one is a serial code (all numbers)??

    Thank you.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,493
    You could check out sumproduct function

    http://www.xldynamic.com/source/xld.SUMPRODUCT.html

  3. #3
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Do not hesitate to upload a zipped sample of your worksheet for a precise answer ...
    HTH
    Carim


    Top Excel Links

+ 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