View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default how can i have more than 30 arguements in a SUM

On Jul 25, 9:22 am, RobG2007
wrote:
mine reads =SUM(1 arguement)-(30 arguements)+(30 arguements )
but it says i have to many , is this wrong


What you wrote here is syntactically wrong. When posting questions
like this, it is best to cut-and-paste from the worksheet and edit the
pasted version to simplify, if necessary.

The syntax closest to the above is:

=A1 - sum(B1,B2,...,B30) + sum(C1,C2,...,C30)

An alternative, following Jim's suggestion, might be:

=sum(A1, (C1,C2,...,C30)) - sum(B1,B2,...,B30)

But in this case, I don't think there is anything to be gained by it.
I suspect it is just confusing you.