An easy problem is driving me crazy, may be this is impossible in
Excel...

A B C D
Apple 1 2 Apple 1 2
Apple 2 3 Apple 2 3
Pear 6 *Total 5*
Banana 8 Pear 6
Melone 7 *Total 6*
Banana 8
*Total 8*
Melone 7
*Total 7*

Please have a look at the simple example above. My data is in the
columns A and B.

In cell D1 I have the formula '=b1'. What I would like to do is the
following: I want to drag this formula down, but when I'll do this then
cell D3 will contain the value 6, with the formula '=b3'. However cell
d3 currently contains the formula '=d1+d2' that is the right formula
that I also want to keep.

So, what I would like to do is copying the formula and skipping the
rows that are called 'Total'. In addition I face the difficulty (for
now ignoring the fact that the rows total should contain another
formula) when you copy the formula '=b1' down then in cell D7 the
formula will be '=b7', while it should be '=b5'.

Shortly, does someone know an option in Excel to copy a formula down
with skipping rows.

Please let me know if I'm not clear. Look forward to your ideas, thanks
for your help!


--
Fewebber
------------------------------------------------------------------------
Fewebber's Profile: http://www.excelforum.com/member.php...o&userid=35141
View this thread: http://www.excelforum.com/showthread...hreadid=549014