Sum formula is not adding up properly
Gary,
I tried this. I thought this may have been the issue previously becauase at
one point I had the entire sheet working, however when I added some
tasks....it no longer worked.
I have tasks compiled together, each one group with a sum and then the sum
cells are totaled at the bottom. 2 of the sum cells are not summing properly.
Any more ideas?
Michelle
"Gary''s Student" wrote:
No real problem. Your math is probably fine; formatting needs fixing.
Select the cell with the sum in it.
Format this cell as Time 37:30:55
--
Gary's Student
"Michelle" wrote:
I am summing up hours in Excel and the sum formula is not working Properly.
For 2 of my 5 cells are adding correctly, but the other 2 when added to the
formula throw the entire thing off.
They are all formatted the same in 13:33 format to measure the # of hours
spent on an activity.
What would the reason be that two of them are not working? (it is almost
like exel is substracting hours when these 2 cells are added)
|