range of values
 

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

range of values
 

$B$98+$B$99+$B$100+$B$101+$B$102+$B$103+$B$104
sum($B$98:$B$104)
--
Don Guillett
SalesAid Software

"exceluser2" wrote
in message ...

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

range of values
 

Try this:

=ROUNDDOWN((B98/SUM($B$98:$B$104))*C98,0)

HTH,
Elkar


"exceluser2" wrote:


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

range of values
 

=ROUNDDOWN((B98/SUM($B$98:$B$104))*C98,0)


Gord Dibben MS Excel MVP


On Thu, 6 Jul 2006 17:44:15 -0500, exceluser2
wrote:


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