Posts by Snjpverma

    Re: Addition based on the column heading


    Quote from AliGW;783446

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    *


    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.

    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