+ Reply to Thread
Results 1 to 7 of 7

How to use SUMIF Forumula in this condition

  1. #1
    Registered User
    Join Date
    03-17-2006
    Posts
    53

    How to use SUMIF Forumula in this condition

    Please see the attached file

    I want to use sumif formula with criteria in column E & Column F when I type in E, "done" and F "Vh" than some the Data of Column B.



    Thanks
    Kamal Singh
    Attached Files Attached Files

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Flag a status using 2 criteria

    Using your posted file....
    try this:

    Please Login or Register  to view this content.
    Copy that formula down as far as needed.

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Another option

    =IF(E2&F2="Wipvh","Done","Open")
    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  4. #4
    Registered User
    Join Date
    03-17-2006
    Posts
    53

    Hey man i am asking the formula "sumif"

    Hey man i am asking the formula "sumif" in this case....

    Please help....

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Sumif for Done

    =SUMIF(G:G,"Done",B:B)
    HTH

    VBA Noob

  6. #6
    Registered User
    Join Date
    03-17-2006
    Posts
    53

    Once more please

    =SUMIF(G:G,"Done & Wip",B:B)

    Please tell how can the above formula will be correct....


    Please once more time help


    Thanks

  7. #7
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Try

    =SUMPRODUCT((E2:E4="Wip")*(G2:G4="Done")*(B2:B4))
    Change range as required. Note Sumproduct can't work on whole column

    see link for more on sumproduct

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

    VBA Noob

+ 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. Sort column when using countif & sumif functions
    By kzprivate in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2008, 08:33 PM
  2. exclude several values with one condition
    By Brigitte_P in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2007, 12:58 PM
  3. Multiple condition SUMIF
    By DanSherwood in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-13-2007, 10:22 AM
  4. Multiple criteria use in SUMIF
    By chamdan in forum Excel General
    Replies: 8
    Last Post: 07-09-2007, 05:44 PM
  5. Multiple Condition SumIf Formula
    By JP7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2007, 09:57 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