range of values

[exceluser2]

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

[Don Guillett]

$B$98+$B$99+$B$100+$B$101+$B$102+$B$103+$B$104
sum($B$98:$B$104)
--
Don Guillett
SalesAid Software
[email protected]
"exceluser2" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[Elkar]

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

[Gord Dibben]

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


Gord Dibben MS Excel MVP


On Thu, 6 Jul 2006 17:44:15 -0500, exceluser2
<[email protected]> 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