Excel: Have a cell count

Hi all, Alright, so I know this will take VBA. I would like for cell A1 to add 1 (to count) the number of times a word (yes) appears in cell a2. Example: cell A1 = 0, A2 = yes then A1 = 1, A2 = no then A1 = 1, A2 = yes then A1 =2 Any help would be appreciated Ahhhhh, this is driving me crazy

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of May 31, 2015.

For more resources for Microsoft Excel