Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 tracking error
I recently started using excel 2003 and built a spread sheet and when I sum a
group of cells it is calculating cell above it into the sum and I received the following tracking error. "the formual in the cell refers to a range that has additonal numbers adjacent to it" The cells in the forumal are correct - the ones I want in the formual, however, it is calculating two cells above the sum total. -- sl |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 tracking error
xl2002+ have some warnings to developers. If xl looks at your data and sees
something that looks inconsistent, then it'll give you that warning. Dates stored as text numbers stored as text inconsistent formulas and the warning you got are a few. Tools|options|error checking tab will show you the list (that you can toggle on/off). So if you know your formula is correct, you can ignore that warning. ===== I don't understand what that second question is, though. starlifter wrote: I recently started using excel 2003 and built a spread sheet and when I sum a group of cells it is calculating cell above it into the sum and I received the following tracking error. "the formual in the cell refers to a range that has additonal numbers adjacent to it" The cells in the forumal are correct - the ones I want in the formual, however, it is calculating two cells above the sum total. -- sl -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 tracking error
Only one question, I found how to turn off the error icon. The problem is
the sum is inocorrect. The formula is correct, for some reason it is calculation two cells about the sum that I do not want to be part of the sum. -- sl "Dave Peterson" wrote: xl2002+ have some warnings to developers. If xl looks at your data and sees something that looks inconsistent, then it'll give you that warning. Dates stored as text numbers stored as text inconsistent formulas and the warning you got are a few. Tools|options|error checking tab will show you the list (that you can toggle on/off). So if you know your formula is correct, you can ignore that warning. ===== I don't understand what that second question is, though. starlifter wrote: I recently started using excel 2003 and built a spread sheet and when I sum a group of cells it is calculating cell above it into the sum and I received the following tracking error. "the formual in the cell refers to a range that has additonal numbers adjacent to it" The cells in the forumal are correct - the ones I want in the formual, however, it is calculating two cells above the sum total. -- sl -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 tracking error
Can you post the formula and then post what cells you wanted included in that
formula? starlifter wrote: Only one question, I found how to turn off the error icon. The problem is the sum is inocorrect. The formula is correct, for some reason it is calculation two cells about the sum that I do not want to be part of the sum. -- sl "Dave Peterson" wrote: xl2002+ have some warnings to developers. If xl looks at your data and sees something that looks inconsistent, then it'll give you that warning. Dates stored as text numbers stored as text inconsistent formulas and the warning you got are a few. Tools|options|error checking tab will show you the list (that you can toggle on/off). So if you know your formula is correct, you can ignore that warning. ===== I don't understand what that second question is, though. starlifter wrote: I recently started using excel 2003 and built a spread sheet and when I sum a group of cells it is calculating cell above it into the sum and I received the following tracking error. "the formual in the cell refers to a range that has additonal numbers adjacent to it" The cells in the forumal are correct - the ones I want in the formual, however, it is calculating two cells above the sum total. -- sl -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 tracking error
I have tried it several ways, selecting a blank cell and hitting the SUM icon
and typing in the range and by selecting a blank cell and highlighting the cells I wanted to SUM. Any way I try it still calculates the cells above, which I do not want in the SUM. Want cells D3:N3 in the SUM and it calculates those plus O2 and O1. Never had this happen before....... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 tracking error
So you're using this formula:
=sum(D3:N3) I don't think you're getting O2:O1 included in this sum. (Well, unless you have a formula in D3:N3 that includes those values--but that's not quite the same thing.) If you select D3:N3 and then rightclick on the bottom right corner of the statusbar (where those embossed boxes are), you can select Sum. Do you get the results you expect? If there's a problem, maybe selecting smaller and smaller ranges will help isolate that problem. And if this doesn't help, please post the exact formula that you're using. And all the values in D3:N3. I think that's the only way to help. starlifter wrote: I have tried it several ways, selecting a blank cell and hitting the SUM icon and typing in the range and by selecting a blank cell and highlighting the cells I wanted to SUM. Any way I try it still calculates the cells above, which I do not want in the SUM. Want cells D3:N3 in the SUM and it calculates those plus O2 and O1. Never had this happen before....... -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 tracking error
Well you were correct, it was not any data from the O column. There was a
shrunk column and it was pulling data from that column. I had never seen the tracking error before. Thanks for your help, it did make me look in the right area! -- sl "Dave Peterson" wrote: So you're using this formula: =sum(D3:N3) I don't think you're getting O2:O1 included in this sum. (Well, unless you have a formula in D3:N3 that includes those values--but that's not quite the same thing.) If you select D3:N3 and then rightclick on the bottom right corner of the statusbar (where those embossed boxes are), you can select Sum. Do you get the results you expect? If there's a problem, maybe selecting smaller and smaller ranges will help isolate that problem. And if this doesn't help, please post the exact formula that you're using. And all the values in D3:N3. I think that's the only way to help. starlifter wrote: I have tried it several ways, selecting a blank cell and hitting the SUM icon and typing in the range and by selecting a blank cell and highlighting the cells I wanted to SUM. Any way I try it still calculates the cells above, which I do not want in the SUM. Want cells D3:N3 in the SUM and it calculates those plus O2 and O1. Never had this happen before....... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 installation error | Excel Discussion (Misc queries) | |||
#VALUE! error: vlookup works in Excel 2000 but not 2003 | Excel Discussion (Misc queries) | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |