+ Reply to Thread
Results 1 to 5 of 5

SUMIF Formula with Multiple Criteria

  1. #1
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    SUMIF Formula with Multiple Criteria

    Greetings Earthlings

    Require a simple SumIf formula where one of the criteria Cols needs to be tested on all values with the exception of "1" (range Zero to 40)

    Sample attached

    Cheers
    hammer
    Attached Files Attached Files
    If you have found solving my problem/s to be an interesting and educational exercise then how about Repping me up?
    No idea why I need Rep, other than feeling left out....

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: SUMIF Formula with Multiple Criteria

    try =SUMIFS(DATA!F2:F13,DATA!D2:D13,1,DATA!P2:P13,"<>1")
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,890

    Re: SUMIF Formula with Multiple Criteria

    Try with
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Also
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Re: SUMIF Formula with Multiple Criteria

    Those identical two work just peachy!
    Many thanks sandy(no caps) and avk.

  5. #5
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: SUMIF Formula with Multiple Criteria

    You are welcome

    Have a nice day

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] sumif multiple criteria with indirect formula
    By Neilesh Kumar in forum Excel General
    Replies: 0
    Last Post: 02-19-2018, 11:01 AM
  2. Formula to sumif with multiple criteria
    By hern in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-16-2017, 06:56 PM
  3. SUMIF or SUMIF's formula with multiple criteria
    By jackiemariee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 06:19 PM
  4. Sumif formula using multiple criteria
    By juksie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-23-2012, 05:44 AM
  5. sumif formula multiple criteria
    By simpson in forum Excel General
    Replies: 13
    Last Post: 07-04-2011, 07:36 AM
  6. Array Formula w/ Multiple SumIf Criteria
    By Andy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. Multiple Criteria in a SUMIF formula
    By JCARROLL in forum Excel General
    Replies: 1
    Last Post: 07-20-2005, 05:05 PM

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