Selecting more than 30 cells for sum

F

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
 
D

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
 
R

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
Click to expand...

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
 
M

marksNWO

Just add another SUM() to the statement.

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

Mark :)
 
Top