Discussion Locked

Limit on SUM command in excel 97

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Does anyone know if there is a limit of 31 non concurrent cells that can be placed in a sum command . ie (=sum(A1,b5,c6......). I ask this because I get an error when I try to put more than 31 in.

2 replies

by cstevens

yes, there is a limit of having between 1 and 30 arguments in a sum command. I would add 30 in one cell, the balance in another, and then add those 2 cells together.

by rms

Confirmed what I had thought, but the solution could of been better. I am using a formula as follows to get arounf the problem =a1+c5+e7+sum(d7:d10)......

This discussion is closed to new replies.