Auto change a letter in selected cells to something else, automatically show the total

Hello new to the form.

I have an Excel sheet with column where I keep track if I received a document. So the answers can either be Yes or No. Is there a way to have y/Y answers autofill/autocorrect to Yes? Where simply typing y or Y will automatically change to Yes?

Then have another cell, where I automatically populate the total number of Yes answers so I can keep a running total at the top of the sheet. I tried googling it and non of the answers seemed to work. Thank you in advance!

This is Excel 2010 for a PC.

The first time you need to enter "Yes" in full, and then as long as the cells below it are contiguous you only need to type Y or y and Excel will auto-correct to Yes, so you just press Enter. The same for No.

To get a running count, you can use a formula like this:

=COUNTIF(A$2:A$100,"y*")

Hope this helps.

Pete

Hey Pete_UK!!! Thanks man!!! That freaking worked perfectly. Really appreciate the sound guidance.

Glad to be able to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

Done and done! Thanks again for even more sound guidance