Selecting more than 30 cells for sum

[funkmaster]

Hello just wondering, to help out someone at work , he
has an worksheet with over 30 cells all over the place
that he wants to sum up some like B3+B5+B9 and so on but
when he gets to 30 it errors on him, selecting too many
cells, ( its like excel 97 or something) just wondering
if there is another way of selecting mutilpe cells but
with gaps inbetween..

cheers

wayne

 

[Don Guillett]

this might be a little better
=SUM(B2,C5,D3)

or a macro assigned to a button

Sub sumhigh()
MsgBox Application.Sum(Selection)
End Sub

 

[Don Guillett]

or
Sub sumhigh()
range("a1")= Application.Sum(Range("b2,c5,d3"))
End Sub

 

[Ron Rosenfeld]

Hello just wondering, to help out someone at work , he
has an worksheet with over 30 cells all over the place
that he wants to sum up some like B3+B5+B9 and so on but
when he gets to 30 it errors on him, selecting too many
cells, ( its like excel 97 or something) just wondering
if there is another way of selecting mutilpe cells but
with gaps inbetween..

cheers

wayne

1. There may be no requirement to use the SUM function; merely use the '+'
operator and you can add up as many non-contiguous cells as you wish.

2. If there is some particular reason for using the SUM function, rather than
just the addition operator, combine some of the non-contiguous cells into named
ranges.


--ron

 

[marksNWO]

Just add another SUM() to the statement.

Example, sum(a1,a2,...a30)+sum(b1,b2...)

Mark

 

[Guest]

Cheers for that will pass it on

cheers

funkmaster