Results 1 to 3 of 3

How to aggregate AMOUNT into NEW AMOUNT according to PART Code?

Threaded View

  1. 09-27-2020, 03:15 AM #1
    Sakurayuki
    Sakurayuki is offline
    Registered User
    Join Date
    08-31-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    94

    How to aggregate AMOUNT into NEW AMOUNT according to PART Code?

    example

    Before B2 to B9 are blank, they belong to the B2 range, and then the AMOUNT which belongs to this range E2:E8 data is summarized and written in the new column F

    Can someone please help me ? It would be much appreciated. Thanks in advance
    Attached Files Attached Files
    Last edited by Sakurayuki; 09-27-2020 at 05:13 AM.
    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] Calculate Projected Annual amount from Dollar value (Amount) and varying time intervals
    By old dawg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2016, 07:29 PM
  2. [SOLVED] Need to find a negative amount and match it to the positve amount based on Acct# and Date
    By sbrandhorst in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-07-2016, 07:49 PM
  3. Calculate an end date for fixed amount of work by a variable amount of monthly effort
    By FatFingers in forum Excel General
    Replies: 2
    Last Post: 11-21-2014, 09:35 AM
  4. [SOLVED] Folder has X amount of jpeg files. How to automate creating links for those X amount of fi
    By JPWRana in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-24-2013, 09:50 AM
  5. [SOLVED] In pivot match vertical row amount with the horizontal column -amount and highlight that
    By Goku in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2013, 02:04 AM
  6. How can I calculate amount of time left based on amount spent?
    By KLD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2006, 11:25 AM
  7. Sum a $ amount in part of a field
    By Sion Romaine in forum Excel General
    Replies: 1
    Last Post: 04-30-2005, 01:09 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