asked

I need to create an Excel spreadsheet where cells may contain either 'Y', 'N', or 'N/A'. I need a formula that will add one to a total for each 'Y' to total all 'Y's, add one to a total for each 'N' to total all 'N's, and add one to a total for each 'N/A' to total all 'N/A's. The result will give three totals. Please help.

September 7th, 2024

Sign Up to View Answers

Create an account to view answers and interact with the community!