|
Number rows in a dynamic range
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 |
Number rows in a dynamic range
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 |
Number rows in a dynamic range
Thank you very much!!! Biff Wrote: 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 -- fishmen ------------------------------------------------------------------------ fishmen's Profile: http://www.excelforum.com/member.php...o&userid=34120 View this thread: http://www.excelforum.com/showthread...hreadid=538921 |
Number rows in a dynamic range
You're welcome!
Biff "fishmen" wrote in message ... Thank you very much!!! Biff Wrote: 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 -- fishmen ------------------------------------------------------------------------ fishmen's Profile: http://www.excelforum.com/member.php...o&userid=34120 View this thread: http://www.excelforum.com/showthread...hreadid=538921 |
| All times are GMT +1. The time now is 07:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com