+ Reply to Thread
Results 1 to 2 of 2

Multiple Criteria in a SUMIF formula

  1. #1
    JCARROLL
    Guest

    Multiple Criteria in a SUMIF formula

    I am tryring to use a SUMIF formula with two differnt criteria. I.E. Sum IF
    <>Blank or Blank. Every time I add the second criteria it cancels out the
    first one. Any suggestions?

  2. #2
    sebastienm
    Guest

    RE: Multiple Criteria in a SUMIF formula

    Hi,
    You can use the SUMPRODUCT function as follow:
    =SUMPRODUCT( (Criteria1) * (Criteria2) * ... * (RangeToSum) )
    The * between criteria behave as an AND
    Eg:
    =SUMPRODUCT ((A1:A100>10) *(A1:A100<=20) *(B1:B100="G") *(D1:D100))
    --
    Regards,
    S├ębastien


    "JCARROLL" wrote:

    > I am tryring to use a SUMIF formula with two differnt criteria. I.E. Sum IF
    > <>Blank or Blank. Every time I add the second criteria it cancels out the
    > first one. Any suggestions?


+ 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