SUM function won't allow more than 30 non-adjacent cells

J

juanfranela

When writing a SUM formula, I am unable to incorporate more than 30
non-adjacent cells into my formula. Is there a way around this limit besides
using subtotals?
 
P

Pete_UK

Try this:

=SUM(up_to_30_cells) + SUM(up_to_another_30_cells) etc

Hope this helps.

Pete
 
B

Bob Phillips

=SUM((cell1,cell2,cell3, ..., cell15),(cell16,
cell17,cell18,cell30),cell(31,etc.))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
R

RagDyeR

Try this:

=Sum((1,2,3,4, ... 50,51,52,53 ... etc.))

It's the *double* parens that enables the extra values.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

When writing a SUM formula, I am unable to incorporate more than 30
non-adjacent cells into my formula. Is there a way around this limit
besides
using subtotals?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top