+ Reply to Thread
Results 1 to 3 of 3

Subtotal of multiple items purchased by each customer, number of items purchased by

  1. #1
    Registered User
    Join Date
    04-27-2021
    Location
    Dubai
    MS-Off Ver
    2010
    Posts
    2

    Subtotal of multiple items purchased by each customer, number of items purchased by

    Help me find the formula for following

    1) Find subtotal of multiple items purchased by each customer

    2) Find Total number of items purchased by each customer
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-27-2021
    Location
    Dubai
    MS-Off Ver
    2010
    Posts
    2
    Invoice attached please help me with assignment
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,100

    Re: Subtotal of multiple items purchased by each customer, number of items purchased by

    Hello Riyki and Welcome to Excel Forum.
    Please paste the following into cell J4, drag the fill handle over to cell K4 and then, while J4:K4 are still selected, drag the fill handle down to cell K8:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Need to make sequence number changes based on year purchased.
    By suffian5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2020, 02:18 AM
  2. Need to Find Items Most Frequently Purchased Together
    By BiggerOnion in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2019, 06:46 PM
  3. [SOLVED] Total items purchased within fiscal year using a dropdown.
    By helmerr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-19-2017, 03:28 PM
  4. Finding all parts that were only purchased by one customer
    By gbarrm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-01-2016, 03:06 PM
  5. Populating Vouchers With Purchased Items For Auction
    By ElectroPulse in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-27-2015, 11:55 PM
  6. [SOLVED] Identify Customer Based on $ Amount Purchased
    By clockspring in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2014, 11:02 PM
  7. Repeat list of names by number of ballots purchased
    By Laliberte78 in forum Excel General
    Replies: 4
    Last Post: 12-20-2011, 10:01 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