a limit on sum calculation?

  • Thread starter Thread starter Todd
  • Start date Start date
T

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
 
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.
 
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
 
There is a limit of 30 arguments in a function in
excel. Can I work around this? I need 39.
Click to expand...

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
 
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
 
Try

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

/i.

Todd said:
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?
Click to expand...
 
Back
Top