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
- How to calculate 90 days from date in excel - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - 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 B2-AR2, 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 B2-AR2, 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