+ Reply to Thread
Results 1 to 3 of 3

Horizonal SUMIfs

  1. #1
    Registered User
    Join Date
    09-09-2006
    MS-Off Ver
    Excel (Office 365 ProPlus)
    Posts
    47

    Horizonal SUMIfs

    Hi

    Im trying to produce a SUMIF, where the column moves about. Expected input and output in the attached.

    Appreciate any help

    Jay
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: Horizonal SUMIfs

    In R8:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Copy down.

    In S8:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Copy down.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,523

    Re: Horizonal SUMIfs

    In R8 and copied down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In S8 and copied down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In T8 and copied down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

+ 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. Horizonal Axis Values
    By cookhouse in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-18-2018, 06:20 PM
  2. modifying the horizonal axis
    By Elainefish in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-03-2013, 09:24 AM
  3. [SOLVED] Horizonal Running Totals
    By thecommish4444 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2012, 09:52 AM
  4. Horizonal running totals
    By thecommish4444 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2012, 10:50 PM
  5. Vertical and horizonal search
    By Jonathan78 in forum Excel General
    Replies: 11
    Last Post: 12-22-2009, 02:58 PM
  6. add horizonal color coding to values
    By chart problems in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-16-2006, 03:30 PM
  7. [SOLVED] Horizonal Line Chart
    By Volsfan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-08-2005, 08: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