Excel is a great software for many different reasons. Here I illustrate the use of the COUNTIF formula so you don’t have to manually count for example (Yes’s and No’s) in a Wedding RSVP list lets say. Enter this forumla and it will automatically calculate the yes’s and no’s for you.