![]() ![]() Again, I have checked the cell formatting for the range of cells, as well as for the formula cell.Īny help, advice, or insight is greatly appreciated. ![]() Both were created in the same version of excel though. The one and only factor that I can think of which could be effecting this (assuming that the coding for excel could possibly be flawed) is that I had copied the worksheet in question into an existing workbook while retaining the original theme (to retain cell colors). If this is false then my whole mathematical world of calculating SD, SEM, residuals, etc. Am I missing something here? because I have long been under the impression that the sum of a set of numbers is obtained by adding them together. /rebates/&252futhatya-and-mamta. ![]() Now if I enter the formula '=AO35+AO36+AO37+AO38+AO39' excel returns the correct value of 63. Cells in the referenced range were formatted as numbers, and I've also tried 'general.' Digging into the next layer, excel returns a value of 0 for both '=SUM(AO35:AO39)' and '=SUM(AO35,AO36,AO37,AO38,AO39)' which have values of 3, 41, 1, 3, 15. I was given a '#DIV/0' error when trying to calculate the proportion of a cell's content to the sum of the cells in a range (e.g. I'm having problems with what I would hope to be the most robust and simple excel formula. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |