+ Reply to Thread
Results 1 to 6 of 6

Formula to add Range of items

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,709

    Formula to add Range of items

    I have Ref no. in Col A on Sheet "Data" and values in Col B


    I need to sum the values based on a range of Ref no's on sheet 'Summary"


    for eg ref Z-763000 to Z-763500. the current Range may only have values for Eg Z-763000,Z-763020,Z-763200. I would like a formula that will change the values if new ref No. in the range is added at a later stage


    I have attached some sample data
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Formula to add Range of items

    You need to split the ranges in the summary so that the start ref# is in column A and the end ref# is in column B, then this formula in C2 will give you the results you need.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    You will need to make sure that the format of all ref#'s is the same, Z-763500 is not the same as Z763500 (there are 2 like this in your summary ranges).

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,709

    Re: Formula to add Range of items

    Thanks for your input & advise Jason

  4. #4
    Registered User
    Join Date
    08-06-2012
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2021, Google Sheet
    Posts
    38

    Re: Formula to add Range of items

    Please see the attachment.
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Formula to add Range of items

    Mofasol, please provide your answers in full in the forum, not just in an attachment.

    Exception can be made for complex solutions, or significant changes to the layout. Neither of which apply here.

  6. #6
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,709

    Re: Formula to add Range of items

    Thanks for the help, Mofasol

+ 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. [SOLVED] Formula to show what items are being used on a range from a table list
    By zaibuojantis in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-15-2019, 08:27 AM
  2. [SOLVED] Adding Items to List box from cell range but skipping items duplicated in another range
    By alteredbeast in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2017, 04:16 AM
  3. [SOLVED] Formula to calculate cost based and items listed in a range
    By A440 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-02-2017, 09:16 AM
  4. Formula to pull out all items that fall in date range
    By mahalek1976 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-30-2015, 10:37 AM
  5. [SOLVED] Count items not included in a data validation range sourced from named range
    By L plates in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2015, 01:05 PM
  6. [SOLVED] Formula- Count of items that meet a specific range criteria
    By Excel Dumbo in forum Excel General
    Replies: 4
    Last Post: 12-05-2012, 01:54 AM
  7. Replies: 1
    Last Post: 06-24-2005, 12:21 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