Results 1 to 5 of 5

Sum weight based on dropdowns

Threaded View

  1. 03-15-2023, 11:20 AM #4
    windknife
    windknife is online now
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,942

    Re: Sum weight based on dropdowns

    Another way

    J4
    =SUMPRODUCT((B4:H4=Sheet2!$B$2:$B$52)*Sheet2!$I$2:$I$52)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Creating Dropdowns and Following On Relationships between Further Dropdowns
    By KevinExc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-16-2022, 07:03 PM
  2. Dropdowns Based on 2 Criteria
    By raybeiler1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2022, 09:16 PM
  3. [SOLVED] Expected output based on 3 dropdowns
    By Neilesh Kumar in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 05-17-2021, 04:22 AM
  4. [SOLVED] VBA for dropdowns based on another dropdowns
    By abhi_jain80 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2016, 05:14 AM
  5. Help calculating the total weight lost from starting weight D1
    By rgainey201 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 12-31-2014, 06:16 PM
  6. [SOLVED] look up based on multiple dropdowns
    By nellyc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2013, 07:27 AM
  7. Auto Calculate Shipping Weight/Cartons and Package Weight.
    By suhailsiddiqui09 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2013, 06:48 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