There are two easy solutions:

1. Cascade the sums - that is use more than one sum function.
2. Make your collection of disjoint cells into a name range

--
Gary''s Student - gsnu200793


"Egozite" wrote:

I have a string of noncontiguous cells in excel that I need the total of, but
I can't enter more that 30 using the sum function