For the function below:

=ROUNDDOWN((B98/($B$98+$B$99+$B$100+$B$101+$B$102+$B$103+$B$104))* C98,0)

rather then specifing $B$98+$B$99+$B$100+$B$101+$B$102+$B$103+$B$104...
how can I specify a range with less characters? Like $B$98 to $B$104


--
exceluser2
------------------------------------------------------------------------
exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338
View this thread: http://www.excelforum.com/showthread...hreadid=559105