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)

 

[Elkar]

Try this:

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

HTH,
Elkar

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP