+ Reply to Thread
Results 1 to 2 of 2

SUMIF statement

Hybrid View

  1. #1
    Registered User
    Join Date
    06-04-2008
    Posts
    1

    Red face SUMIF statement

    So I made a compound SUMIF statement, as follows:

    =SUM(SUMIF($K1,"VI",$G1),SUMIF($F1,"P",$G1))

    (If the characters "VI" are in column K, it will add column G.
    & If the character "P" is in column F, it will add column G.
    The cell with the formula will add column G IF it has VI and P in the other columns.)

    I have no idea if that makes sense. Either way, the formula seems to work but it's resulting in 0 when it should be 475. Is there a way to simplify what I have or change it so it's working correctly.

    Here is a screenshot if it helps. My explination was... bad.

    sumif.JPG

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    Hi and welcome to the forum.

    Try this sumproduct formula an see if it helps:
    =SUMPRODUCT(($K$2:$K$5000="VI")*($F$2:$F$5000="P")*$G$2:$G$5000)
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

+ 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. Nested IF Statement with Multiple Criteria
    By Hoopsah in forum Excel General
    Replies: 6
    Last Post: 07-23-2007, 10:01 AM
  2. With Statement Questions
    By OzTrekker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2007, 02:44 AM
  3. excel sumif sorting
    By blnewsom in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-19-2007, 11:18 AM
  4. SUMIF with dual criteria?
    By surfengine in forum Excel General
    Replies: 7
    Last Post: 11-10-2006, 07:29 PM
  5. advanced (i think) if statement help
    By ukrockhit in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-06-2006, 11:41 AM

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