+ Reply to Thread
Results 1 to 4 of 4

SUM column after two parameters are met

  1. #1
    Registered User
    Join Date
    10-25-2010
    Location
    edmonton canada
    MS-Off Ver
    Excel 2007
    Posts
    84

    SUM column after two parameters are met

    I need to sum a column after two parameters are met
    so far I have =COUNTIFS(Mon!H:H,"GPTLiftgate*",Mon!J:J,"departure") I want to SUM column AK on the Mon! sheet
    Last edited by AliGW; 07-17-2017 at 10:31 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    MS Office Excel 2007
    Posts
    4,969

    Re: SUM column after two parameters are met

    "I need to sum a column"

    Then why are you using COUNT ? You should be using SUM, in this case SUMIFS

    Try
    =SUMIFS(Mon!AK1:AK100000,Mon!H1:H100000,"GPTLiftgate*",Mon!J1:J100000,"departure")

    It is better to qualify a range by specifying the rows rather than a whole column, ie H1:100000 is better than H:H
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    10,918

    Re: SUM column after two parameters are met

    As you have tried, I have done it for you THIS TIME ONLY. In future, give your threads meaningful and precise titles. Thanks. You may now continue with your query.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  4. #4
    Registered User
    Join Date
    10-25-2010
    Location
    edmonton canada
    MS-Off Ver
    Excel 2007
    Posts
    84

    Re: SUM column after two parameters are met

    will do

    thank you for your help and patience

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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