+ Reply to Thread
Results 1 to 3 of 3

Summing up horizontally

  1. #1
    Registered User
    Join Date
    05-14-2018
    Location
    Hong Kong
    MS-Off Ver
    MS 365
    Posts
    68

    Summing up horizontally

    I need to sum up the Ord Unit & Sales Amt horizontally from Jan - May/17.
    Currently, I simply add up each cell as shown in the picture under total column. Is there any formula function the same without adding up each cell one by one?
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    484

    Re: Summing up horizontally

    Try placing the following formula in cell L3 and drag-copying it down and right as needed:

    =SUMIF($B$2:$K$2,L$2,$B3:$K3)

  3. #3
    Registered User
    Join Date
    05-14-2018
    Location
    Hong Kong
    MS-Off Ver
    MS 365
    Posts
    68

    Re: Summing up horizontally

    Works perfectly. Many thanks for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autofill Horizontally
    By trescuervo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2018, 10:51 PM
  2. sum if horizontally
    By arshab1 in forum Excel General
    Replies: 3
    Last Post: 02-10-2017, 03:14 AM
  3. [SOLVED] Summing Tiles and Summing Tile Decors
    By makinmomb in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-09-2014, 12:15 AM
  4. [SOLVED] Help with Summing Duplicates, deleting rows after summing and filling col. for unsummed
    By solidrock1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2014, 09:11 AM
  5. [SOLVED] Filter horizontally?
    By Raymond in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-24-2006, 04:35 PM
  6. Summing Columns-revolves around summing particular items
    By savv32 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-06-2005, 09:05 PM
  7. Sort horizontally
    By 0-0 Wai Wai ^-^ in forum Excel General
    Replies: 4
    Last Post: 08-26-2005, 06: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1