Can I add up the cells that have something in them and put the result in a box?

[matelot2]

Once, a long time ago, I seem to remember I had an excel file that had a column of cells that could be totaled at the bottom according to the contents.
If the box had anything in it, in this case either the word 'yes' or 'no' (if I got the form or just a verbal reply), the total box at the bottom of the column had a number that counted just those boxes.
I have tried all ways to reproduce the result but am failing. Can someone help with a formula to go either in each box and/or a formula in the totals box?
thanks.

 

[matelot2]

Found it thanks. I am sure this is not the way I did it before but simply putting =COUNTA (A3:A41) in my total box does it.