Addition based on the column heading

  • Sheet1


    BaseBaseBase




    =SUM(INDEX($A$2:$I$11,,MATCH(2,1/($A$1:$I$1="Base"))))


    I am using the above given array formula to add the values of the left-most column with word "Base" as a Header. The formula adds the whole column correctly. Can someone please help modify the formula so that it will add only the row 2, 3, 7, 8 and 10 ? In the above scenario my left-most column with header as "Base" is G1. hence the formula should add the values of G2, G3, G7, G8 AND G10. Any help is highly appreciated.


    http://www.mrexcel.com/forum/e…based-column-heading.html

  • Re: Addition based on the column heading


    [cp]*[/cp]

    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 the like icon bottom right.

    :!:Forum Rules

  • Re: Addition based on the column heading


    Quote from AliGW;783446

    [cp]*[/cp]


    Ali, did I not give the link here? I can clearly see the link of Mrexcel in my post. Any member can go and check the post I believe. Please let me know if I am going wrong somewhere.

  • Re: Addition based on the column heading


    Sorry - I did not see it as it did not appear as a link. My mistake. :)

    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 the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!