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.




    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.…based-column-heading.html