Excel Help

Okay, so now I'm looking for help regarding checklists and tallies. I'd like to learn to make something like this...

http://www.mediafire.com/?2a23xatgo61d4l6

But so far I'm really having no luck with functionality and have absolutely no idea how this person would have created the tally and the progression bar. The person also password protected it so I can't investigate so I'm hoping someone here would know at least some tricks.

From a rough look through the sheet, the checkbox is implemented by assigning a boolean (true/false) value to each item. I don't know if there is some user-friendly way to update that "I GOT THIS ITEM" other than manually altering the cell (into =true()).
Even though, from the way it is used later on, it could very well have been a line of text saying "TRUE".

For the progress summation, he did the function CountIf, which counts the number of cells that meet a certain criteria.
In this sheet, the criteria was that the boolean cell has to display a text that reads "TRUE".

I'm not sure if this is what you're asking for since it's probably too simple. Perhaps you can't see the code because of this password protection or something?