Number rows in a dynamic range

[fishmen]

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 numbe
of lines in a dynamic range can vary.
I need Sum(Name1;Name2) - (85)

Thank yo

 

[Biff]

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]

Thank you very much!!!

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

in
message news:[email protected]...

 

[Biff]

You're welcome!

Biff

Thank you very much!!!