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
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