calculations quit working
What's octml?
octml means October Mocha Lite ... octml is in the column that the formula
is looking for ... This same formula is in the spreadsheet for every year
since 1998 ... there is a similar formula for every other flavor and every
month ... and there are more things that calculate than just theoretical
gallons ...
This same formula worked in September ...
:(
"Dave Peterson" wrote:
What's octml?
Maybe:
=SUMIF(Flavor,"="&OctML,TheoryGals)/1.78125
or
=SUMIF(Flavor,OctML,TheoryGals)/1.78125
CJ wrote:
If you select one of these cells that is not calculating,
what do you see in the CELL?
0
What do you see in the Formula Bar?
=SUMIF(Flavor,"=OctML",TheoryGals)/1.78125
Under Tools/Options/Calculations -- what is selected?
Automatic
Are these non-calculating cells dependent on macros (either in the cell
itself
or in a precedent cell)?
No
Under Tools/Macros/Security, what is the security level?
Low
"Ron Rosenfeld" wrote:
On Sun, 13 Nov 2005 03:39:01 -0800, "CJ" wrote:
Our new network administrator tried to keep all company computers from going
on the internet, and in doing so he royally screwed up several spreadsheets
on my computer ... He eventually had to buy me a new computer, but one
spreadsheet still will not calculate ...
I've tried everything I know to get it to work ... All formula cells that
were calculating previous to his blooper still have data in them ... every
cell since then is not working ... and even with the new computer, the cells
don't formulate ...
HELP ...!!!
If you select one of these cells that is not calculating,
what do you see in the CELL?
What do you see in the Formula Bar?
Under Tools/Options/Calculations -- what is selected?
Are these non-calculating cells dependent on macros (either in the cell itself
or in a precedent cell)?
Under Tools/Macros/Security, what is the security level?
--ron
--
Dave Peterson
|