Excel Help with Percent calculations
Solved/Closed
Scorchy
rizvisa1
- Posts
- 2
- Registration date
- Wednesday February 4, 2009
- Status
- Member
- Last seen
- February 5, 2009
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Excel Help with Percent calculations
- Excel formula for vat calculation - Guide
- How to calculate position in excel ✓ - Forum - Office Software
- Fuel surcharge calculator excel - Forum - Excel
- Excel vba calculator - Guide
- Excel calculation is incomplete - Guide
3 replies
Oterwill
Feb 25, 2009 at 07:43 AM
- Posts
- 5
- Registration date
- Tuesday February 24, 2009
- Status
- Member
- Last seen
- February 25, 2009
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
Jun 13, 2010 at 02:13 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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