Sum of Specific Named Columns in Excel


  • Hi,

    i want to create aformula in excell  . i have a scenario like that i have one row in which i am giving names to columns like A,B C, etc

    I want to sum those columns in which i have given the name 'A' only.

    Help Required..





    • Moved by KJian_ Monday, October 25, 2010 7:54 AM (From:SQL Server Data Access)
    Saturday, October 23, 2010 8:05 AM


  • It depends on what you mean by 'those columns"



    where row 1 has you column names, and row 2 has the data to sum, or


    where row 1 is the same, but the data to sum is in rows 2 to 10

    HTH, Bernie
    • Marked as answer by Bessie Zhao Monday, November 1, 2010 9:30 AM
    Wednesday, October 27, 2010 10:14 PM

All replies