Hi
I have created a workbook with 4 sheets that are basically the same. I want to be know how to do the following:
1. I have a column of cells (all sheets) that I want the inputer to only be able to type "yes" or "no" in. (or leave blank).
2. I have a cell that I want to total only the "yes" answers on the sheet the cell resides.
3. I also have a cell that I want to total only the "yes" answers on ALL sheets.
Any help with this would be very appreciated.
Thanks in advance
-LV
Bookmarks