Results 1 to 7 of 7

Formula to extract number of sold items

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2024
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Microsoft 365, Microsoft Excel for Mac, version 16.80.
    Posts
    3

    Formula to extract number of sold items

    Hello all,

    I have a huge amount of sales data (sample in the attachment). Currently, I fill column A (= sold amount of 'No. 503 Ginger Delight BIO - 1 kg') manually. Obviously this takes me a lot of time
    So I am looking for a way to automatically extract the sold amount for a specific product. In this case 'No. 503 Ginger Delight BIO - 1 kg'.

    So the request for help is: how can I automatically fill column A for each row?

    I hope somebody can help me.

    Thanks a lot!

    Kind regards,

    Kelly
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. NUMBER OF ITEMS SOLD out of TOTAL NUMBER OF ITEMS
    By glennas94 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-22-2022, 11:26 PM
  2. Need formula to calculate items sold x items= profit
    By MaryLouJW in forum Excel General
    Replies: 1
    Last Post: 08-01-2019, 11:14 PM
  3. Calculate Inventory and number of items sold
    By rtfish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2019, 07:04 PM
  4. getting total number of items sold from a list
    By rchapman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2014, 06:42 AM
  5. Replies: 1
    Last Post: 07-02-2013, 09:17 PM
  6. Replies: 10
    Last Post: 01-05-2013, 12:31 PM
  7. Calculationg number of items sold after a specific date
    By JohnFletcher66 in forum Excel General
    Replies: 3
    Last Post: 10-28-2011, 07:39 AM

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