Results 1 to 6 of 6

PRODUCT SUM with ITEMCODES

Threaded View

  1. 05-20-2020, 01:48 PM #5
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: PRODUCT SUM with ITEMCODES

    Formula: copy to clipboard 
    =IFERROR(INDEX($D$4:$D$8,MATCH(0,COUNTIF($G$3:G3,$D$4:$D$8),0)),"")
    in h3 and use Ctrl+Shift+Enter drag it to right
    Formula: copy to clipboard 
    =SUMIF($D$4:$D$8,H$3,$C$4:$C$8)
    in H3 and drag it to right

    Punnam
    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. [SOLVED] Replacement product finder - Searching for matches based on various product attributes
    By gingert88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2017, 01:17 PM
  2. Product formula that requires 2 Ingredients to create 1 Product and sort droplist.
    By Teknoslasher in forum Excel General
    Replies: 9
    Last Post: 10-16-2014, 07:46 AM
  3. Generating product names from product attributes and formatted fractions
    By WM3 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 09-10-2014, 08:56 AM
  4. [SOLVED] I'm receiving a Run-Time error 1004 while trying to delete a product from a product list.
    By redsab in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2014, 10:03 PM
  5. Translate Row W/ Product# And All Colors To Product# W/ 1 Color Per Row (Images included)
    By DreKole in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-20-2014, 03:38 PM
  6. [SOLVED] Find Product Details in Another Sheet based on Product ID and Copy some Fields From there
    By kevalkothari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2012, 10:43 AM
  7. [SOLVED] Need Function that will find ordered product, and display the product code in a 2nd workbk
    By rollerden in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2012, 08:52 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