I have a column of data with several hundred rows. I want to add every
other row and show the results in another cell. How would i go about
doing this?

How about if i wanted to add every 2nd and 3rd row? Is there a
function i can use to do this?

In other words:

1
2
3
4
5
6
7
8
9
10

I want to sum up the (2+3) then skip a row (5+6) skip another row (8+9)
etc.


--
MrSandman
------------------------------------------------------------------------
MrSandman's Profile: http://www.excelforum.com/member.php...fo&userid=7826
View this thread: http://www.excelforum.com/showthread...hreadid=520860