+ Reply to Thread
Results 1 to 3 of 3

Summarize products sold

  1. #1
    Registered User
    Join Date
    09-01-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Summarize products sold

    Hi,

    I have monthly sales report. Now I want to summarize the activity that took place within the month

    Pls look attached file. I am looking for a formula to summarize in words the activity by 1) region and 2) by product

    Pls need help me in summarise above way.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Summarize products sold

    Try

    =COUNTIFS($B$1:$B$15,"AMERICAS")
    and
    =SUMPRODUCT(--((($C$1:$C$15="BALLOON")+($D$1:$D$15="BALLOON"))>0))

  3. #3
    Registered User
    Join Date
    09-01-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Summarize products sold

    Thanks Bob.

    You have addressed my calculation aspect.

    Actually i need excel to be able to automatically tell me in sentence on which regions and product sold.

    Example:
    - We have sent goods to region such as Americas (Baloon, Candy, Umbrella), Asia (Hat, Inner, Jeans, Kakhi, Mat, Sandal, Tees, Vest, and Robe), CIS (Robe), Europe (Napkin and Ugg)
    - Americas, Asia etc is per region exist in the list. Diffrent months may have diffrent region
    - Baloon, Candy, Umbrella etc is per product listed in column C and D

    Hope this clarifies further. Apologize for the cofusion

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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