Summing excel spread sheets

  • Thread starter Thread starter Jim Knaggs
  • Start date Start date
J

Jim Knaggs

I am adding cell totals from weekly expense report sheets to create
quarterly total for different types of expenses. I can get the the ga
cell to allow me to sum all of them for one quarter but I can't get th
entertainment cell and a few other cell totals to allow me to sum al
of them. Most of the sheets allow me to click on them and preform the
function but several won't allow me do that. They don't get the motio
indicator that lets you know you can go to the the + for adding. Th
total amount of cells to add from the sheets is the same no matter wha
the expense. The sheets that won't allow me to sum are near the end o
the sheets yet some after that allow me to preform the + function. I
there something wrong with the sheet, the cell, or is there a glitch i
the the microsoft office excel 2003 I am not aware of? :confused
 
Hi jim

a couple of things
first,
not sure what the problem really is, but go to a blank cell near one of the
cells that won't let you sum it and type
=ISNUMBER(A1)
where A1 is the value of the cell

if true is returned then it is a number a should let you sum it, however, if
false is returned then excel thinks it is text not a number .

second,
if the cell you are summing is always the same cell just on different sheets
(e.g. =Sheet1!A1+Sheet2!A1+Sheet3!A1 etc) then you can rewrite the formula
as =Sum(Sheet1:Sheet3!A1)
- easy way to do this,
click where you want the answer
type
=SUM(
click on the first sheet tab, hold down your shift key, click on the last
sheet tab and then click on the relevant cell, now press Enter

Let us know how you go.

Cheers
julieD
 
Julie D.:
Thanks for the reply. After a good nights rest I tried goin
back and adding the cells from the sheets until it would not let me ad
any more. I then accepted the formula by saying OK. I then returned t
the formula and clicked on the fx for formula and began where I lef
off and it allowed me to finish adding the remainder of the cells t
the formula so I could finish out a group. So I have been able to mak
it work at this time. Seems like there are a lot of sharp people i
this forum. I'm sure I'll be posting again sometime in need of help
Take care
 
Back
Top