Converting test to numbers and adding into a summary page

[Laura]

I have mulitple pages in my workbook that contain both text and numeric
information. I need to know how to convert the words to numbers and have them
add the numbers onto my summary page.
Example:
I have equipment parts listed at the top of columns, and each cell under is
either yes or no. I need to it to count my "no"s and show me on my summary
page how many "no"s I have on each part, in order to place my parts order.

Example of from worksheet:
Alarm Cable Charging Cable
YES YES
NO NO
YES YES
YES YES
YES YES

Example from summary sheet:

PARTS NEEDED
Alarm Cable Charging Cable
2 6
12 3

THanks,
Laura

 

[tim m]

=COUNTIF(A1:A5,"NO")

This will count the number of NO's from cells A1 to A5