I want to add different cell in One Cell

  • Thread starter Thread starter Atif
  • Start date Start date
A

Atif

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 said:
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.
Click to expand...

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) are:
=sum(A1:A50) and = sum(B12:B20) right up to =sum(AX41:AX78)
then your grand total could be:
=sum(A99:AX99)

Phil, London
 
Back
Top