Converting test to numbers and adding into a summary page

L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top