Formula Correction Needed

PrismPSG

Hello,

Can you please assist in fixing the formula below to count the cells in the column that are either "Y" or "N/A"? The formula I have currently works but only accounts for "Y".

=COUNTIF({Column1}, "Y") / COUNT({Column1})

Kelly Moore

Hey @PrismPSG

=COUNTIFS({Column1}, OR(@cell="Y",@cell="N/A")) / COUNT({Column1})

Will this work for you?
Kelly