Excel Help with Percent calculations
Solved/Closed
Scorchy
Posts
2
Registration date
Wednesday February 4, 2009
Status
Member
Last seen
February 5, 2009

Feb 5, 2009 at 01:25 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  Jun 13, 2010 at 02:13 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  Jun 13, 2010 at 02:13 PM
Related:
 Excel Help with Percent calculations
 Excel date format dd.mm.yyyy  Guide
 Excel free download  Download  Spreadsheets
 Number to words in excel  Guide
 Excel marksheet  Guide
 How to calculate 90 days from date in excel  Guide
3 responses
Oterwill
Posts
5
Registration date
Tuesday February 24, 2009
Status
Member
Last seen
February 25, 2009
19
Feb 25, 2009 at 07:43 AM
Feb 25, 2009 at 07:43 AM
At first I didnt understand, but then I did some of my own example and see what you mean. I used three formulas with differeing results when the 0% is deleted and left with a blank.
I started with AVERAGE(B2:AR2) and tested it against SUM(B2:AR2)/COUNTA(B2:AR2): which is just the average formula in its mathimatical simplest. sum of the numbers divided by sum of the number of data points. I thought that the counta would count the blank, but as I should have known it only counts if there is something in the cell. So this however gave me the same result when the 0%s were omitted.
I then did the same thing, but to count the data points, as I assume you have data in each cell from B2AR2, I used a more complicated way to count. I did:
SUM(B2:AR2)/(COLUMN(AR2)COLUMN(B2)+1)
This worked when 0%s were omitted since it wasn't counting anything but the column reference numbers which are absolute. the +1 is included in the end because the number is inclusive.
(obviously format the cell as a Percent to get the %)
Let me know if it helps or solves your problem:
OT
I started with AVERAGE(B2:AR2) and tested it against SUM(B2:AR2)/COUNTA(B2:AR2): which is just the average formula in its mathimatical simplest. sum of the numbers divided by sum of the number of data points. I thought that the counta would count the blank, but as I should have known it only counts if there is something in the cell. So this however gave me the same result when the 0%s were omitted.
I then did the same thing, but to count the data points, as I assume you have data in each cell from B2AR2, I used a more complicated way to count. I did:
SUM(B2:AR2)/(COLUMN(AR2)COLUMN(B2)+1)
This worked when 0%s were omitted since it wasn't counting anything but the column reference numbers which are absolute. the +1 is included in the end because the number is inclusive.
(obviously format the cell as a Percent to get the %)
Let me know if it helps or solves your problem:
OT
How to return the average of arguments in the cell rather than the formula; formula to appear in the formula field only,
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 13, 2010 at 02:13 PM
Jun 13, 2010 at 02:13 PM
what are you looking for again. Could you explain more.
Apr 23, 2009 at 10:11 AM
with the following for example let me say cell a3+d3+d4 maube I get the answe as 40 then I want that 40 on the other cell maybe f3 to be 2 as a level in other wors from 40 to 49 must be level 2 automatically , I need a formular to do it
please help
Sep 25, 2009 at 01:04 AM
Example: I have a total of 56 cars, I can drive daily. (Next to each car listed separately, car 1, car 2, car 3, etc, I list the # of passengers in that car if it were used that day). I want the formula to count the # of cars used that day (based on the cells that have passengers in them) and divide that total by 56.
Mar 25, 2010 at 05:03 AM
May 22, 2010 at 01:14 AM