Thanks Bob!

I'll give that a try.

"Bob Phillips" wrote:

Bracket some of them, e.g.

=SUM((A1,a3,a5,a7),(B1,B3,B5,B7),...)

you get the idea

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cheryl" wrote in message
...
I want to sum 52 non-contiguous cells in column E. The SUM function
limits
me to 30. Is there a way around this?