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

1. ## 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.

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. ## Re: Calculate Percentage of Items Sold based on Cell Values and No. Of Rows

In C5 in Totals use formula:
Formula:
`Please Login or Register  to view this content.`

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

That's great Kaper appreciate the speedy response.

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

and thanks for a reputation point and for marking thread SOLVED

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