Adding the values on even rows/odd rows.

[gjfeng]

please refer to this post to prevent dupilcates

http://www.mrexcel.com/forum/showthread.php?t=322724

 

[Dave]

Huh?
Dave.