+ Reply to Thread
Results 1 to 4 of 4

Calculate Percentage of Items Sold based on Cell Values and No. Of Rows

  1. #1
    Registered User
    Join Date
    04-23-2007
    Posts
    34

    Calculate Percentage of Items Sold based on Cell Values and No. Of Rows

    Hello, I am trying to calculate the % of unsold items on my spreadsheet.

    https://docs.google.com/spreadsheets...it?usp=sharing

    On my Furniture sheet, each row represents a single item. I have 8 items in total.

    Items that have not yet been sold have a blank 'Resell' value, and these have been marked in green:

    example.png

    Therefore, 5/8 items have not yet been sold (62.5%). I would like to represent this value as a percentage on my Totals sheet.

    The sheet should also allow for new items (rows) to be added to the Furniture sheet, so basically all rows from A2 downwards if populated should add to the row total and subsequent calculation.

    I hope that's clear and thanks again in advance for any help.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Calculate Percentage of Items Sold based on Cell Values and No. Of Rows

    In C5 in Totals use formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    04-23-2007
    Posts
    34

    Re: Calculate Percentage of Items Sold based on Cell Values and No. Of Rows

    That's great Kaper appreciate the speedy response.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Calculate Percentage of Items Sold based on Cell Values and No. Of Rows

    Glad it worked for you,
    and thanks for a reputation point and for marking thread SOLVED

+ 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. To make a formula to calculate items sold by each sales person.
    By ssbns in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-18-2021, 08:30 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 percentage of open items
    By geliedee in forum Excel General
    Replies: 3
    Last Post: 06-25-2019, 02:36 AM
  4. 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
  5. Replies: 1
    Last Post: 03-16-2018, 12:52 PM
  6. Replies: 1
    Last Post: 07-02-2013, 09:17 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