| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Conditional Formatting & Dynamic Range | Excel Worksheet Functions | |||
| Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
| Dynamic named range across multiple sheets | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Linear Mode
