I have several worksheets that are set up the same. I need a sub or function that will count numbers in cells and put the count in a cell . I tried

=countif(b8:bj19,"2")+countif(b8:bj19,"3")+countif(b8:bj19,"4")

works fine, but I need it to look at every other row

Example (b8:b19,d8:d19,f8:f19...bj8:bj19) 31 ranges

The criteria would be the same. Also, is it possible to have the macro start when you double click a cell and have the macro check that cell on every worksheet for the same countif statement? If so, how?

Thanks, In advance for the help.