+ Reply to Thread
Results 1 to 2 of 2

How do i calculate sales ?

  1. #1
    Registered User
    Join Date
    07-30-2020
    Location
    Malaysia
    MS-Off Ver
    2007
    Posts
    1

    Lightbulb How do i calculate sales ?

    Hi, I have opened a business and am trying to produce a table so that I can calculate number of each item sold.

    The challenges to this were:
    -> One item has different names on each website (for example, Heal (White) and Convi are the same item).
    -> Number of rows change every day based on that day's sales.

    I am a newbie to excel, and I wish to save time by producing a table like the one shown below . (Healing (White) = Heal (White) , Convi)

    Currently I am using the sort function and it is a time-consuming process.

    Please do help! thank you xxx
    Attached Images Attached Images
    Last edited by AliGW; 07-31-2020 at 01:54 AM. Reason: Urgency notice removed.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: [URGENT] How do i calculate sales ?

    I would suggest that while each web site has a different name for the same item that you identify your products with numerical codes. In that manner, no matter what you name them, they are categorized by a unique number. Once you have that information, you can then summarize by the account numbers.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. [SOLVED] Calculate sales tax
    By Unca Wook in forum Excel General
    Replies: 4
    Last Post: 05-25-2016, 06:57 AM
  2. Replies: 16
    Last Post: 03-09-2016, 05:01 PM
  3. Replies: 1
    Last Post: 03-09-2016, 12:16 PM
  4. [SOLVED] Calculate number of days between sales and prior sales date
    By maacmaac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-03-2013, 03:07 PM
  5. [SOLVED] Calculate Sales
    By edesign95 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 11-09-2012, 04:19 AM
  6. [SOLVED] Calculate total sales adjustments for each sales person
    By Adama in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-02-2012, 06:26 PM
  7. [SOLVED] formula to calculate sales tax from total sales
    By Deanna in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-05-2005, 04:05 PM

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