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

$B$98+$B$99+$B$100+$B$101+$B$102+$B$103+$B$104
sum($B$98:$B$104)
--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"exceluser2" <exceluser2.2ajpkz_1152225901.5387@excelforum-nospam.com> wrote
in message news:exceluser2.2ajpkz_1152225901.5387@excelforum-nospam.com...
>
> 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
>

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
>
>

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


Gord Dibben MS Excel MVP


On Thu, 6 Jul 2006 17:44:15 -0500, exceluser2
<exceluser2.2ajpkz_1152225901.5387@excelforum-nospam.com> 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