View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fishmen
 
Posts: n/a
Default 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