+ Reply to Thread
Results 1 to 3 of 3

Formula to Sum Range that has the same value in another cell

  1. #1
    Registered User
    Join Date
    03-13-2023
    Location
    Mankato, MN, USA
    MS-Off Ver
    MS Office 2021
    Posts
    31

    Formula to Sum Range that has the same value in another cell

    Hello all,
    I have a report that pulls the details for my sales orders but I only need the total units per order and not the detail. Is there a formula to auto sum a range of cells for only the range where the value in cell A matches?

    EXAMPLE 2.27.25.xlsx
    Example is attached.

    Thank you
    Deb

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,343

    Re: Formula to Sum Range that has the same value in another cell

    A pivot table might be the easiest. Select the range -> insert pivot table -> instruct pivot table to use sales order (or customer) for the row labels and sum of units for the pivot values.

    If you must use a formula, then something based on a SUMIFS() function would seem appropriate.
    1) Build a list of unique entries from sales order or customer. The UNIQUE() function can do this, if supported by your version.
    2) Adjacent to the list of unique entries, a SUMIFS() function like =SUMIFS($D$2:$D$21,$A$2:$A$21,reference to identifier)

    Which strategy do you like?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-13-2023
    Location
    Mankato, MN, USA
    MS-Off Ver
    MS Office 2021
    Posts
    31

    Re: Formula to Sum Range that has the same value in another cell

    Awesome! I think a Pivot Table will work best, thank you very much!

    Deb

+ 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] Dynamic range formula which finds the last cell in a dataset as the formula range too
    By Coopereto in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-25-2023, 11:08 AM
  2. [SOLVED] VBA to copy a formula from a cell range and paste it to a cell range based on date
    By dedark05 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-19-2019, 04:41 AM
  3. Replies: 10
    Last Post: 12-12-2019, 07:27 PM
  4. [SOLVED] Make data range in formula shift for a whole range when copying cell
    By Zaron in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-21-2016, 06:37 AM
  5. [SOLVED] if cell in range has formula equals cell in range on other worksheet
    By Little Guy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-25-2015, 03:38 PM
  6. Replies: 1
    Last Post: 03-02-2015, 11:18 AM
  7. Replies: 6
    Last Post: 06-05-2014, 05:02 PM

Tags for this Thread

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