software

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: www.excelforum.com/member.php...oamp;userid=34120
View this thread: www.excelforum.com/showthread...hreadid=538921Hi!

Try this:

Assume Name1 is in cell A2.

=SUM(B2:INDEX(B2:B65536,MATCH(quot;Name2quot;,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

quot;fishmenquot; gt; wrote in
message ...
gt;
gt; Hi,
gt; How can I to count up quantity of lines in a dynamic range.
gt; for example:
gt;
gt; ColumnA; ColumnB
gt; Name1; -
gt; 1;20
gt; 2;30
gt; 3;15
gt; ......
gt; ......
gt; 10; 20
gt; Name2; -
gt; 1;10
gt; 2;15
gt; 3;4
gt; 4;8
gt; ....
gt;
gt;
gt; The number of lines between Name1 and Name2 is not known and the number
gt; of lines in a dynamic range can vary.
gt; I need Sum(Name1;Name2) - (85)
gt;
gt; Thank you
gt;
gt;
gt; --
gt; fishmen
gt; ------------------------------------------------------------------------
gt; fishmen's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34120
gt; View this thread: www.excelforum.com/showthread...hreadid=538921
gt;

Thank you very much!!!Biff Wrote:
gt; Hi!
gt;
gt; Try this:
gt;
gt; Assume Name1 is in cell A2.
gt;
gt; =SUM(B2:INDEX(B2:B65536,MATCH(quot;Name2quot;,A2:A65536,0)-1))
gt;
gt; I don't know how large your range is so I used to row 65536. Adjust to
gt; fit
gt; your needs.
gt;
gt; Biff
gt;
gt; quot;fishmenquot; gt; wrote
gt; in
gt; message ...
gt; gt;
gt; gt; Hi,
gt; gt; How can I to count up quantity of lines in a dynamic range.
gt; gt; for example:
gt; gt;
gt; gt; ColumnA; ColumnB
gt; gt; Name1; -
gt; gt; 1;20
gt; gt; 2;30
gt; gt; 3;15
gt; gt; ......
gt; gt; ......
gt; gt; 10; 20
gt; gt; Name2; -
gt; gt; 1;10
gt; gt; 2;15
gt; gt; 3;4
gt; gt; 4;8
gt; gt; ....
gt; gt;
gt; gt;
gt; gt; The number of lines between Name1 and Name2 is not known and the
gt; number
gt; gt; of lines in a dynamic range can vary.
gt; gt; I need Sum(Name1;Name2) - (85)
gt; gt;
gt; gt; Thank you
gt; gt;
gt; gt;
gt; gt; --
gt; gt; fishmen
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; fishmen's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=34120
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=538921
gt; gt;--
fishmen
------------------------------------------------------------------------
fishmen's Profile: www.excelforum.com/member.php...oamp;userid=34120
View this thread: www.excelforum.com/showthread...hreadid=538921You're welcome!

Biff

quot;fishmenquot; gt; wrote in
message ...
gt;
gt; Thank you very much!!!
gt;
gt;
gt; Biff Wrote:
gt;gt; Hi!
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; Assume Name1 is in cell A2.
gt;gt;
gt;gt; =SUM(B2:INDEX(B2:B65536,MATCH(quot;Name2quot;,A2:A65536,0)-1))
gt;gt;
gt;gt; I don't know how large your range is so I used to row 65536. Adjust to
gt;gt; fit
gt;gt; your needs.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;fishmenquot; gt; wrote
gt;gt; in
gt;gt; message ...
gt;gt; gt;
gt;gt; gt; Hi,
gt;gt; gt; How can I to count up quantity of lines in a dynamic range.
gt;gt; gt; for example:
gt;gt; gt;
gt;gt; gt; ColumnA; ColumnB
gt;gt; gt; Name1; -
gt;gt; gt; 1;20
gt;gt; gt; 2;30
gt;gt; gt; 3;15
gt;gt; gt; ......
gt;gt; gt; ......
gt;gt; gt; 10; 20
gt;gt; gt; Name2; -
gt;gt; gt; 1;10
gt;gt; gt; 2;15
gt;gt; gt; 3;4
gt;gt; gt; 4;8
gt;gt; gt; ....
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; The number of lines between Name1 and Name2 is not known and the
gt;gt; number
gt;gt; gt; of lines in a dynamic range can vary.
gt;gt; gt; I need Sum(Name1;Name2) - (85)
gt;gt; gt;
gt;gt; gt; Thank you
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; fishmen
gt;gt; gt;
gt;gt; ------------------------------------------------------------------------
gt;gt; gt; fishmen's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=34120
gt;gt; gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=538921
gt;gt; gt;
gt;
gt;
gt; --
gt; fishmen
gt; ------------------------------------------------------------------------
gt; fishmen's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34120
gt; View this thread: www.excelforum.com/showthread...hreadid=538921
gt;