#div/0 or #value error

Hi All-
I have a likely easy question, but I'm completely stumped. I have a worksheet that I'm trying to calculate the percentage of how many times "y" appears in a column (#y/total of y & n). If there is no data at all in the column, of course, I get a #div/0 error with this formula:

=COUNTIF(Table3[JAN Target Bx % Achieved],"Y")/(SUM(COUNTIF(Table3[JAN Target Bx % Achieved],"Y"),COUNTIF(Table3[JAN Target Bx % Achieved],"N"))))

It works as long as there is at least 1 "y" or "n" in the coulmn, but i get the error if no data has been entered. I tried correcting with this and keep getting a #value error:


=IF(Table3[JAN Target Bx % Achieved]="","",COUNTIF(Table3[JAN Target Bx % Achieved],"Y")/(SUM(COUNTIF(Table3[JAN Target Bx % Achieved],"Y"),COUNTIF(Table3[JAN Target Bx % Achieved],"N"))))

Any help would be greatly appreciated!
Thank you in advance!

If you want to get rid of #value error, try this:

Formula:

Please Login or Register  to view this content.

Thank you both so much! Your help is very much appreciated!

FYI,

You can simplify this part

SUM(COUNTIF(Table3[JAN Target Bx % Achieved],"Y"),COUNTIF(Table3[JAN Target Bx % Achieved],"N"))
to
SUM(COUNTIF(Table3[JAN Target Bx % Achieved],{"Y","N"}))

So the overall formula becomes
=IFERROR(COUNTIF(Table3[JAN Target Bx % Achieved],"Y")/SUM(COUNTIF(Table3[JAN Target Bx % Achieved],{"Y","N"})),"")