Hi,
How can I to count up quantity of lines in a dynamic range.
for example:

ColumnA; ColumnB
Name1; -
1;20
2;30
3;15
.......
.......
10; 20
Name2; -
1;10
2;15
3;4
4;8
.....


The number of lines between Name1 and Name2 is not known and the number
of lines in a dynamic range can vary.
I need Sum(Name1;Name2) - (85)

Thank you


--
fishmen
------------------------------------------------------------------------
fishmen's Profile: http://www.excelforum.com/member.php...o&userid=34120
View this thread: http://www.excelforum.com/showthread...hreadid=538921