HELP! I haven't worked in Excel much, but I know there's an equation I can
use to get the information I'm wanting....
For example, I'm trying to keep tract of how many apples everyone eats. I'm
going to assign the letter "a" to Amy, "b" to Betty, "c" to Cathy, etc. Amy
eats an apple, so in cell A1, I'm going to type "a", and I want a "1" to go
to cell B6. (=COUNTIF(A1,"a")
Now here's where I'm getting myself confused....now Cathy's eaten an apple,
so I want to type a "c", and I want a "1" to go to cell B8.
(=COUNTIF(A1,"c"). But when I type the "c", it takes my "1" away from Amy.
Do I need to add something to my formula?!
Also, I need to start my count at "0". How can I do this, and keep tract of
my TOTAL amount of apples eaten?!