more arguments have been specified for this function than are allo

  • Thread starter Thread starter pm
  • Start date Start date
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?
 
My best guess:

Try putting ( ) around some arguments like this:

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

Each set of ( ) is 1 argument.
 
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
specify non-contiguous cell range as arguments to TTEST() 2
more than 30 fields in one Sum function 9
sum of more than 30 non-adjacent cells 12
Extend the number of arguments of a function 9
Average more than 30 numeric arguments 15
Differnce function and argument for amounts in adjacent cells 3

Back
Top