+ Reply to Thread
Results 1 to 2 of 2

SUMIF with two contraints?

  1. #1
    Registered User
    Join Date
    09-26-2005
    Posts
    34

    SUMIF with two contraints?

    Hello-

    I am looking to do a SUMIF function with two constraints. Is this possible?

    For example if I have a list of data and one column is the month sold, and another column is a product type, and the 3rd column is dollar amount sold. Is it possible to do a SUMIF function that says if column A is March and column B is Product X, then sum column C?

  2. #2
    Valued Forum Contributor
    Join Date
    03-25-2004
    Location
    Boston, MA US
    Posts
    1,094
    You could use SUMPRODUCT

    =SUMPRODUCT(--(A1:A9="March"),--(B1:B9="x"),(C1:C9))

    Does that help?

    Steve

+ 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