Get the Average percentages? Also, #DIV/0! error
 

Two topics/questions for you:
First, I have a list of percentages:

Vendor A - 15 out of 20 approved- 75%
Vendor B - 5 out of 10 approved - 50%
Vendor C - 2 out of 5 approved - 40%

What I want to get is an AVERAGE or MEAN of the percentages but I don't want
to go back to the original numbers to get it - I want to work off the
percentages because with the totals being different, it will skew the
percentages. I want to be able to say XX% is the average approval rate for
all vendors and I don't want whether they have a large or small business to
affect the percentage. How do I do this?

Second question: if a line is empty because the data has not been entered
yet, it shows a #DIV/0! error message which then in turn creates that error
messages in the totals at the bottom. I want to be able to have the Excel
spreadsheet ignore any cells that have that error message and not count it in
the total averages. Does that make sense?

thank you!
JR

Get the Average percentages? Also, #DIV/0! error
 

so, for the first quetion, just do =(sumif(A:A,"Vendor
A",B:B)/countif(A:A,"Vendor A"))*(sumif(A:A,"Vendor
B",B:B)/countif(A:A,"Vendor B"))*"))*(sumif(A:A,"Vendor
C",B:B)/countif(A:A,"Vendor C"))

This multiplies the percents only

For the #DIV/0 issue, enter =if(dividend = 0,"",divisor/dividend)

"Roady" wrote:

Two topics/questions for you:
First, I have a list of percentages:

Vendor A - 15 out of 20 approved- 75%
Vendor B - 5 out of 10 approved - 50%
Vendor C - 2 out of 5 approved - 40%

What I want to get is an AVERAGE or MEAN of the percentages but I don't want
to go back to the original numbers to get it - I want to work off the
percentages because with the totals being different, it will skew the
percentages. I want to be able to say XX% is the average approval rate for
all vendors and I don't want whether they have a large or small business to
affect the percentage. How do I do this?

Second question: if a line is empty because the data has not been entered
yet, it shows a #DIV/0! error message which then in turn creates that error
messages in the totals at the bottom. I want to be able to have the Excel
spreadsheet ignore any cells that have that error message and not count it in
the total averages. Does that make sense?

thank you!
JR