Hmmm, ok...

My knowledge of excel is fairly limited, here is an example of some of the formulas i was trying to get it to work. That obviously didnt work... XP

=countif((A5:A10,"A")+countif(B5:B10,"1"))

=sumproduct(--(A5:A10,"A")--(B5:B10,"1"))

SO as i enter the options in to columns of a and b, it counted up in my table.