Try typing ="S"="s" in a cell. If you do that you'll see that excel doesn't differentiate between a capital or a lower case S.
In the attached I made a simple table that adds up the different instances for you. That you can then manipulate.
It's often easier to break down the problem into steps and then solve each step on it's own. Later you'll learn how to solve the problems more efficiently in fewer steps.
/Møller
|