Countif and divide by formula needs to become percentage

[argentraven]

OK, stuck again gang!

I have a spreadsheet where C3 has a capital X as the text in it. Cells E3 through E22 have a value in each of them ranging from 1 to 5. I want to calculate that if C3 has an X, and E3 through E22 has a 5, 4 or 3, then add the number of cells with those values and divide by the total number of cells that E3 through E22 have an X and get a percentage.

Here's my formula so far; =IF(C3:C22="X",COUNTIF(E3:E22, "5")+COUNTIF(E3:E22, "4")+COUNTIF(E3:E22, "3"))/(C3:C22="X")*100

I think it's the back end of the formula that is having issues.

[ChemistB]

Try this

=COUNTIFS(C3:C22, "X", E3:E22, ">=3")/COUNTIF(C3:C22, "X")

Either format cell as percentage or multiply * 100

[argentraven]

Perfect! Thank you!

[argentraven]

Dang! I forgot to add a twist. I need this calculation to be in a different workbook.

This isn't working; =COUNTIFS(Calculations!C3:C22, "X", E3:E22, ">=3")/COUNTIF(Calculations!C3:C22, "X")*100

It returns a 0

[argentraven]

Aha!! I figured it out!

=COUNTIFS(Calculations!C3:C22, "X", Calculations!E3:E22, ">=3")/COUNTIF(Calculations!C3:C22, "X")*100