+ Reply to Thread
Results 1 to 4 of 4

Formula to Sum Transposed Headings

  1. 04-02-2015, 09:36 PM #1
    hammer2
    hammer2 is offline
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Formula to Sum Transposed Headings

    Hi Folks
    Have Headings across one sheet but I have had to Transpose them in another sheet and need to SUM them without having to do each individually.
    Sample sheet attached

    Cheers
    hammer
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-02-2015, 09:42 PM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula to Sum Transposed Headings

    Hi Hammer

    try this formula

    =SUMPRODUCT(($C$1:$BD$1=A13)*($C$2:$BD$11))
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  3. 04-02-2015, 09:49 PM #3
    hammer2
    hammer2 is offline
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Re: Formula to Sum Transposed Headings

    Another winner!
    Thanks yet again AlKey
    Cheers
    hammer
    Reply With QuoteRegister To Reply
  4. 04-02-2015, 09:51 PM #4
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula to Sum Transposed Headings

    Appreciate your feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Slow on transposed sumifs formula
    By eing in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-01-2014, 11:38 PM
  2. Extend series using ref cell formula transposed
    By Gnomie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. Extend series using ref cell formula transposed
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 08:05 AM
  4. [SOLVED] Extend series using ref cell formula transposed
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 09-06-2005, 05:05 AM
  5. Extend series using ref cell formula transposed
    By Gnomie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1