Hi!

Try this:

Assume Name1 is in cell A2.

=SUM(B2:INDEX(B2:B65536,MATCH("Name2",A2:A65536,0)-1))

I don't know how large your range is so I used to row 65536. Adjust to fit
your needs.

Biff

"fishmen" wrote in
message ...

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