a limit on sum calculation?

[Todd]

I have lots of questions today! After I get the formulas
in place I need to sum them. I have 39 columns of data to
sum, each cell has a formula.

= sum(Q13+T13+W13+Z13) is what I tried to use but I get
VALUE. Is 39 to many additions? Where am I going wrong?

Thanks SO much.


Todd

 

[Aladin Akyurek]

Try...

= SUM(Q13,T13,W13,Z13)

instead of using the + operator for one or more of the cells appear to house
a text value instead of a number.

 

[Tim Otero]

Replace the plusses with commas. Proper syntax is =SUM(Item1,Item2,
Item3,...)

tim

 

[Mike Hughes]

Todd,

The correct syntax is =sum(q13,t13) Its the + sign thats incorrect
even better would be =sum(q13:z13) which would sum everything between
columns q to z on row 13

Mike

Mike

 

[Tim Otero]

There is a limit of 30 arguments in a function in

excel. Can I work around this? I need 39.

Hi Todd,

Do as Mike Hughes suggested and sum a range. Instead of
SUM(A13,B13,...,CV13) use SUM(A13:CV13) or name the range and use SUM(Stuff)
where Stuff is the name of the range.

tim

 

[Todd]

I got it, pretty easy. I broke the function in two and it
works. =sum(a1,a3,a3)+ sum(a7,a9,a11) etc

Thanks for the help

Todd

 

[immanuel]

Try

=Sum(...)+Sum(...)

/i.

I tried what you suggested (thank you) It worked! To a
point. There is a limit of 30 arguments in a function in
excel. Can I work around this? I need 39. I suppose I
can split the calc into two cells. Do you know a better
way?