Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SUMIF Function Formula with Multiple Criteria (Excel XP)

    Hi Guys! I am trying to set up a SUMIF function with more than one criteria and it's not working.
    Does anyone have good examples of just such a SUMIF function.

    Thanks!

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SUMIF Function Formula with Multiple Criteria

    Without your criteria it is difficult to answer but you may want to use sumproduct and example can be found here http://www.ozgrid.com/Excel/sum-if.htm
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SUMIF Function Formula with Multiple Criteria (Excel XP)

    You can also find several examples by clicking on the Search button in the Lounge menu bar and searching for sumif multiple criteria.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •