SumIfs
Results 1 to 6 of 6

Thread: SumIfs

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default SumIfs

    Hi! I am trying to do a SumIfs statement. I have a data validation list in a column and and trying to sum if the criteria in that one column matches. All of the posts I have seen have the criteria to look for in separate columns. Is it possible to do a SumIfs if all of the criteria are in the same column? Here is my attempt:
    =sumifs(I8:I24,G8:G24,"Company CC",I8:I24,G8:H24,"Company CK",I8:I24,G8:H24,"Company Cash") Thanks!

  2. #2
    Board Regular tyija1995's Avatar
    Join Date
    Feb 2019
    Posts
    647
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    4 Thread(s)

    Default Re: SumIfs

    Hey how about this:

    SUMPRODUCT((G8:G24="Company Cash")+(G8:G24="Company CC")+(G8:G24="Company CK"),(I8:I24))
    √-1 2³ ∑ π
    …And it was delicious!

  3. #3
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,745
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: SumIfs

    How about
    =SUMPRODUCT((G8:G24={"Company CC","Company CK","Company Cash"})*(I8:I24))
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  4. #4
    New Member
    Join Date
    Jun 2019
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: SumIfs

    This worked, thanks for your help!

  5. #5
    New Member
    Join Date
    Jun 2019
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: SumIfs

    Thank you for taking a look, appreciate it!

  6. #6
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,745
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: SumIfs

    Glad we could help & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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