I want to add different cell in One Cell

Actually, i have the situation that i did total of some amounts in a cell.
And then many more totals like this about 85 totals. Now i want to get Grand
Total of all these "85 totals" by selecting only that cell not a series of
cells. Now the problem is that when i select these cells it add only 30 cells
in One cell not more than this. If anyone can help me to tell the solution
that will highly appriciated.

Atif wrote:
Actually, i have the situation that i did total of some amounts in a cell.
And then many more totals like this about 85 totals. Now i want to get Grand
Total of all these "85 totals" by selecting only that cell not a series of
cells. Now the problem is that when i select these cells it add only 30 cells
in One cell not more than this. If anyone can help me to tell the solution
that will highly appriciated.

I think you posted this to the wrong group (three times!). This group
is for the Access database, and you're talking the language of Excel.

I was surprised to see that the Excel Sum() function can't take more
than 30 arguments, but any of these arguments can be a range: eg A1:B5
denotes a range of 10 cells (on 2 rows in this example). If you
rearrange your layout so that you are totalling _adjacent_ cells, you
may find you need only one (range) argument in the function. So, if
your column totals (all calculated in adjacent cells in row 99) a
=sum(A1:A50) and = sum(B12:B20) right up to =sum(AX41:AX78)
then your grand total could be:
=sum(A99:AX99)

Phil, London