Using Countif/Counta to find percentage.

[JohnDoh]

Hi all.

I'm using

Please Login or Register  to view this content.

I used Col C as the COUNTA ref as it has no gaps.

To try and find the percentage of complete jobs marked as yes or no, but with the odd blank in a large database, but the percentage comes out wrong, any ideas?

[Jonmo1]

In what way is the result wrong?
What result does it actually give, and what result did you expect, and why?

If you're using C for the counta because there are no gaps, then essentially you're doing
=COUNTIF(Database!M2:M2000,"yes")/1999

My assumption would be you should use the same column for the counta as you used to count for Yes.

[JohnDoh]

Forgive my ignorance, I think I understood the formula incorrectly.

I was hoping to show the percentage of yes's over the total entries (blanks are also technically a no).

There are 238 entries of which 235 are yes and 3 blanks, so I was hoping it would show an answer of 98.73% but it comes out as 11.71%

[Jonmo1]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[bsherwin]

Hello All,

I'm new to the forum and any help is greatly appreciated! My issue is trying to count the values in a row of a pivot table greater than the average of all the values in the same row of the pivot table. I'm using the countif and counta in my formula, but must be missing something.

Thank You

[6StringJazzer]

bsherwin, welcome to the Forum. However, you are asking a new question that doesn't have anything to do with the thread you are posting in. Please take the time to review our rules. There aren't many, and they are all important.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.