more arguments have been specified for this function than are allo

P

pm

I am trying to sum a group of numbers and keep getting this message: "more
arguments have been specified for this function than are allowed in the
current file format" How can I correct this?
 
T

T. Valko

My best guess:

Try putting ( ) around some arguments like this:

=SUM((A1,D27,D99,D1071),(AA48,X222,Y19))

Each set of ( ) is 1 argument.
 
G

gibbylinks

I think the problem is that it's not allowing or complaining of too many
parenthesis. Or at least that's what's happened to me. It won't allow me to
complete the formula, and I'm only one short !!
 

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

Similar Threads

error in excell 2007 9
Trying to randomly choose a number from a set list of numbers 8
more than 30 fields in one Sum function 9
Average more than 30 numeric arguments 15
sum of more than 30 non-adjacent cells 12
Possibly Too Many Arguments 7
XNPV Function 1
=COUNTIF How to if 2 or more arguments??? 1

Top