Exclude cells with a defined value from being counted in a formula

[Dietcoke1953]

Hi All:

I have a spreadsheet ( see attached ) which tracks the Corrective Actions for my Quality system. The formula in cell AE3 calculates the % of corrective actions closed in 30 days or less. My problem is that it counts all cells, I want to exclude cells in column "F" that contain the value "Vendor Error" from being counted.

Any assistance is greatly appreciated.

[sati]

Try using this formula in cell AE3

=COUNTIFS($W$10:$W$13981,"<=30",$F$10:$F$13981,"<>Vendor Error")/((COUNT($W$10:$W$13981)+COUNTIF($X$10:$X$13981,"Yes")))

[sati]

to avoid any errors try this formula

=COUNTIFS($W$10:$W$13981,"<=30",$F$10:$F$13981,"<>Vendor Error")/((COUNT($W$10:$W$13981)+COUNTIF($X$10:$X$13981,"Yes")))