Thank you Pecoflyer but not sure how to set this up because I only want every
other cell to be added (horizontally). The answers are yes and no. So I
need a formula to add every other cell across for yes and every other cell
across for no answers. How would I set that up with the dynamic range.
Really appreciate your help!


"Pecoflyer" wrote:


Hi,
easiest way is using 'dynamic ranges'
(http://www.contextures.com/xlNames01.html#Dynamic)

HTH


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30624